uncleroydee
Technical User
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 and cast functions. The query takes a minimum of 35 seconds to run in Query Analyzer but bombs on the web. If I "rem" out two or three of the Unions the query runs on the web successfully. (I've noticed that the SP executes successfully when Internet responsiveness is good, but fails when the web is slow.)
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 SP3
Remote query time-out = 0 (unlimited)
Thanks
"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 and cast functions. The query takes a minimum of 35 seconds to run in Query Analyzer but bombs on the web. If I "rem" out two or three of the Unions the query runs on the web successfully. (I've noticed that the SP executes successfully when Internet responsiveness is good, but fails when the web is slow.)
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 SP3
Remote query time-out = 0 (unlimited)
Thanks