SQL Server Driver, TCP/IP Sockets network error

[qwerty980]

I have an asp page on my webserver that queries a sql server
for updated info on live sport events.Sql server is not on the same box(ver 7.0).And I get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
/cricketscorecard/IndexBody.asp, line 176

The asp page refreshes every 60 seconds.I experience the above mentioned error every 4th to 5th time that the page refreshes.And the "line 176" mentioned also varies.

 

[fluteplr]

General Network error usually means that the connection that was open to the server was disconnected or dropped. It is also possible that if you are running multiple queries over the same connection and the connection is set up to run asyncronous queries that a prior query has not finished when a new query is started.

You might also try using the ole/db driver for sql server rather than the ole/db odbc driver for sql server, that would eliminate one layer and might make your connection more stable.

 

[qwerty980]

Thanks for the suggestion fluteplr.However I moved the asp page to one of my corporate servers and It worked fine.It seems that the webserver was far to busy with other requests.But I will keep your suggestion for the future.