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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy