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 Error

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-13 : 22:51:04
Gary writes "We have an internal website that was built using Macromedia's Dreamweaver Ultradev 4. Each time I try to view the SQL query in a live data mode that would appear on our website, I get the following error.

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[Microsoft][ODBC SQL Server Driver]Timeout expired

TMPy7dx8c6a7.asp line 10.

I have been in contact with the support people at Macromedia, but their knowledge of SQL is limited. They suggested that I edit the registry for Ultradev and set a Connection Timeout value which I did. I set the value for 180 seconds, as the default for Ultradev is 30 seconds.

I launched Ultradev and tried my query again, but received the same response.

I am now thinking that the Timeout is coming from the SQL Server. Anyone have any ideas on how to change the connection timeout default in SQL?

Thanks.

Gary Costigan"
   

- Advertisement -