dbTalk Databases Forums  

MS SQL Server 7.0 DB Error #3121

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss MS SQL Server 7.0 DB Error #3121 in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Cynthia
 
Posts: n/a

Default MS SQL Server 7.0 DB Error #3121 - 07-22-2004 , 09:47 AM






Hi,

Does anyone know how to correct the following error message that is
causing an application to fail:

Error is
DB Error 80040e31 ODBC Driver Error #3121 Timeout Expired

There are some troubleshooting tips as well that address pooling
configuration issues.

I see others have said it is a query that is failing to execute within
a specific time.
Any ideas how to debug this?

Thanks
Cynthia

Reply With Quote
  #2  
Old   
6ef40
 
Posts: n/a

Default Re: MS SQL Server 7.0 DB Error #3121 - 07-22-2004 , 04:10 PM






You can use sql-profiler to monitor your server activity and see which
statement "hangs"
Or you can trace the application itself (provided you have the source
code…)
If everything is OK but slow just increase the timeout intervals
(enterprise manager-server-properties-connections…)

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.