ODBC driver locks up, will using multiple drivers help?
Posted on 2008-10-21
I have an AccPac Order Entry system which runs on Pervasive. All the reports in AccPac are written in Crystal and use the ODBC driver. I have developed several programs that also connect into the Pervasive database via the same ODBC driver. These programs both read and write data to the database.
The ODBC driver has started to intermittently lock up and only restarting the server seems to clear it.
The database still works, just the ODBC connections freeze. Since all programs are using the same ODBC driver name, I was wondering if I created 3 or 4 ODBC drivers to the database and have certain programs use certain named drivers, I might be able to see which group of programs is the culprit.
(I have been unable to find the cause of the lock ups)
This would only work if the ODBC drivers would work independantly of each other. So my question is this concept plausible? If I create 3 ODBC drivers on the server to the same database, will they be completely separate and run via different threads? Any thoughts much appreciated.