Clever Geek Handbook

SQL Server ODBC Driver Error

I have a VB6 application that accesses a database over an ODBC connection. It will work fine for a few hours, after which I get the following error. Any ideas?

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


source to share


2 answers


From a Google bug, it looks like this is just ADO's way of saying that it can't connect - that the server is down. Are there any other services on this server or that use a database that becomes unavailable at the same time as this error? It looks like the client just loses connection, so I would like to look for something like that - a dropped network connection or a crashed / overloaded server to name a few examples.



0


source


Is your program available over the network to access the access file?

If so, I would consider any intermittent network connection issues, especially if your program is always connected to the data source.

Check all the logs that you can see what is happening on your network during the error.



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

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

See also:
Does the error take about the same amount of time after the initial connection?
Is the error occurring in the same amount of inactivity in your application?

0


source






More articles:


All Articles