samedi 3 avril 2021

ODBC driver direct testing on Windows

I have a problem with SQLite ODBC 32-bit driver (http://www.ch-werner.de/sqliteodbc) on Windows 7/10. When installed from provided binary (http://www.ch-werner.de/sqliteodbc/sqliteodbc.exe), the driver loads and works.

When built from the provided source (http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.9998.tar.gz) using MinGW32/Msys, an attempt to establish and ADODB connection or trying to configure the corresponding system DNS in the data source manager, causes an error 126, stating that the driver file could not be found. The error message is useless. Directly replacing the compiled sqlite3odbc.dll with the provided binary makes everything OK.

There is obviously some issue with the built dll. I need a means to call/test the standard ODBC interface directly without the ODBC manager, to track the problem. I do not see any means to do that in the ODBC test tool from Microsoft Data Access SDK. An attempt to establish a connection goes through the ODBC manager and reports the same useless error message.

Is there a Windows tool to directly call/test the standard ODBC interface by directly calling exported routines of the dll driver file?

Aucun commentaire:

Enregistrer un commentaire