SQL Server Timeout error?? HELP!

[jkat]

I am randomly getting this error message with my production sites and I cant figure out what the problem is. (needless to say this is a bad problem to have in production)

Here is the exact error that is displayed on the screen:
----------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver] Timeout expired

/forums/forumsdisplay.asp, line 240
-----------------
on line 240 i have the code that executes an objConn.Open command that opens the connection to my SQL server. The error is not occuring on a SQL query, but on the initial OPEN. I looked everywhere for Timeout settings and I just updated all of my drivers and applied the latest SP to my SQl server. If anyone can help I would greatly appreciate it. Thanks a lot!!!!

-Jason

 

[ColinM]

I think the problem is in the ASP page.

try adding:
Server.ScriptTimeout = 600 (time in seconds)

 

[jkat]

thanks for the help. but i honestly dont think thats the problem. I can get the error when it seems like 4 seconds. i hit a page and BAM, almost instantly i get the error...and again, the error is happening on the objConn.OPEN commend not any actual asp queries or code (loops etc)

thanks!

 

[ColinM]

Have a look at this article:

http://p2p.wrox.com/archive/sql_server/2001-03/120.asp