General information
Forum:
Microsoft SQL Server
Title:
Intermittent ODBC error
We have a web site implemented using Active Server pages and VBScript.
We have the following error message being generated by SQL/Server 7
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
On the face of it, maybe straightforward. However, the circumatances make a big difference, i.e.
1. It NEVER seems to occur when talking to the site via ADSL
2. It ALWAYS occurs when using 56k dial-up. However, if you do excatly the same query immediately afterwards, the problem goes away and back come the results as expected.
3. It SOMETIMES occurs when using an ISDN line - as with dial-up, if you repeat the same query, the problem goes away.
4. It NEVER occurs on LAN test setup with exactly the same software. On both the LAN server and the web server we have the latest Microsoft SPs installed.
The fact that it ALWAYS works with ADSL suggests it isn't an application code problem, but some kind of environment problem. Given the evidence listed above, we assumed it must be a timing problem, so we increased the timeout to 300 seconds. This didn't make the slightest difference.
Anybody have any ideas what's wrong?
Gordon Dennis
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only