April 7, 2008 at 8:55 am
We have an app running on SQL 2000 SP4/ Win2003SP2 that once in a while gets microsoft odbc sql server driver timeout expired. In all of my Internet searches I have really found nothing. Anyone with any help would be appreciated.
April 7, 2008 at 3:18 pm
Are you using link servers?
April 8, 2008 at 5:45 am
No, we are not using any linked servers.
April 9, 2008 at 12:55 am
What kind of application?
Do you use ADO? If so
Just a thought look att
Dim conn As New ADODB.Connection
Dim cmd As New ADODB.Command
conn.ConnectionTimeout = value
and conn.CommandTimeout = value
April 9, 2008 at 5:52 am
Have you identified what query is run on the server when the client timeout occurs? Adding the Attention eventclass to a profiler trace can help with that.
This blog entry that helped me out when I was getting reports of timeout errors: http://blogs.msdn.com/khen1234/archive/2005/10/20/483015.aspx%5B/url%5D
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply