Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 timeout expires exception

Author  Topic 

brianpark
Starting Member

6 Posts

Posted - 2007-06-05 : 18:16:58
Hi,
I am having a problem and I can't resolve it. I have a VB6 module calls C# search engine. I have an runtime error returned from C# engine. Oh, BTW I am using SQL 2000 as a back-end DB.
The error message is Search ended with an exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
This problem is not consistent and I compared two SQL profiler files. and I found when it is working it has 'exec sp_reset_connection' and when it has a problem it has a 'exec sp_datatype_info 0' instead of 'exec sp_reset_connection'
Please help someone.

Thanks in advance.
Brian.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-06 : 10:10:37
See if these help
http://vyaskn.tripod.com/watch_your_timeouts.htm
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -