July 7, 2006 at 3:12 pm
There's view that I can run in the Query Analyzer but when I run it in Enterprise Manager, I keep getting the "ODBC Driver Times Out" error message.
It takes a while to run in QA, over 40 seconds.
I've increased the long query time in the DSN configuration but it still times out in EM.
I can't touch the view (not until I've tried everything else) yet because it was written by someone else...
Anyone know why I would be able to run it in QA but not in EM?
July 7, 2006 at 3:37 pm
It is to do with the way in which EM makes its connections. You should try the new Management Studio if you have a timeout fetish. On big tables a simple column modification will fail with a lovely big .net error! GRRRRRR!
July 7, 2006 at 3:38 pm
I have always had better luck with Query Anaylzer than Enterprise Manager - especially when altering tables...
I wasn't born stupid - I had to study.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply