Pervasive SQL troubles with a Dotnet Class
Posted on 2011-02-24
I recently did an update to a class that connected to Pervasive databases via ODBC and OLEDB
ODBC is what we have been using for years. I recently added OLEDB which I discovered is not compatible 100% with Pervasive versions below 8. A fair number of our customers use 7.9 and thus cannot use OLEDB but will continue to use ODBC.
All code is in vb.net 2005
We are starting to get errors like this these below.
Our customers say that they cannot use their main CRM that uses Btrieve/Pervasive
unable to fill dataadaptor ERROR - unable to allocate an environment handle.
unable to fill dataadaptor ERROR [08S01] [Pervasive][ODBC Client Interface][Client LNA]You have been unexpectedly disconnected from the server. Re-start your application, then access the data source again. Contact your system administrator if you still need assistance.
I am hoping Mithryll will read this and has Ideas since he is the person that has