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-03-18 : 18:54:20
|
Roy writes "In a nutshell, can I reconfigure ODBC somehow to prevent receiving the error:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired" ?
I'm executing a stored procedure Select statement with 6 unions that include mathmatical, cast and str functions. The query takes a minimum of 40 seconds to run locally but bombs on the web. If I "rem" out two or three of the Unions the query runs on the web successfully.
Since it's a management type report that won't be run too often, I'm not overly concerned about the time, but it does have to complete.
NT 4.0 SP 6
SQl Server 7.0
Thanks." |
|
|
|
|
|
ODBC timeout expires while executing SP over the web