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.
| 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" |
|
|
|
|
|