ODBC SQL Server driver error

Question

I have a VB6 app that access's a database thru a ODBC Connection. It will run fine for a few hours then I get the following Error. Any Ideas?

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite(WrapperWrite())

Answer 1

Does your program have to reach across a network to get to the Access file?

If so I'd look into any intermittent network connectivity issues, especially if your program is always connected to the data source.

Check any logs you can to see what's happening on your network at the time of the error.

If possible change your app to connect to the data source only when you need to access it and then disconnect when done.

Is there more than one instance of the program running on the same and/or different machines? If so, do they all get the error at the same time?
If possible try to have more than one instance of you program running on the same machine and see if they all get the error at the same time.

Also:
Does the error happen about the same amount of time after initial connection?
Does the error happen about the same amount of inactivity in your application?

Answer 2

From Googling the error, it sounds like that's just ADO's way of saying it can't connect - that the server is unreachable. Are there are any other services on that server or that use the database that become unavailable at the same time as this error? It sounds like the client is just losing its connection, so I'd look for anything around that - dropped network connectivity, or a downed/overwhelmed server, to name a few examples.