The SQLite Database Engine provides a lightweight C library to access databasefiles using a large subset of SQL92 without the overhead of RDBMS serverprocesses. In order to use that functionality as a desktop database I wrappedthe SQLite library into an ODBC driver.
So far it has been tested with SQLite 2.8.17 and SQLite 3.8.4.2on Windows NT/2000 in MS Excel 97 (MSQUERY) with SQLite databasefiles created on Linux. Support for Win64 exists for both SQLite 2.xand SQLite 3.x versions of the driver, but this has been only partially tested.It also runs on Linux with unixODBC 2.[0-2].xand with libiodbc 3.[05].x.
Another recent experimental project is a Java binding forthe SQLite database engine, which can be foundhere. Docs and Download Refer to the online documentation (made with DoxyGen) and/or get the current source code or the SRPM.
For Win32 operating systems a binary package is available as an NSIS installer in sqliteodbc.exe. It was made with SQLite 2.8.17/3.8.4.2 and a MinGW cross compiler, and contains the driver DLLs and programs for installation and uninstallation of the ODBC driver.
For Win64 operating systems a binary package is available as an NSIS installer in sqliteodbc_w64.exe. It was made with SQLite 3.8.4.2 and a MinGW cross compiler, and contains the driver DLLs and programs for installation and uninstallation of the ODBC driver. Note that this is a 64 bit only driver. If you're using 32 bit software on Win64 you should install the Win32 driver, too.
Chris Wolf kindly provided a build of version 0.72 supporting SQLite3 for MacOSX on PowerPC in the form of an installer package (sqlite3odbc-0.72.dmg) and a build of version 0.83 for MacOSX 10.5 on Intel as another installer package (sqlite-odbc-0.83.dmg).
Steve Palm kindly provided a build of version 0.93 for MacOSX 10.7 on Intel as installer package (sqlite3-odbc-0.93.dmg).
sqliteodbc_dl.exe (EXPERIMENTAL: variant which needs System.Data.SQLite.dll or sqlite3.dll in the Windows system folder) sqliteodbc_w64_dl.exe (EXPERIMENTAL: variant which needs System.Data.SQLite.dll or sqlite3.dll in the Windows system folder) sqliteodbc_msvcr100.exe (EXPERIMENTAL: variant which is linked against MSVCR100.DLL (Visual Studio 2010 runtime) instead of MSVCRT.DLL.) sqliteodbc_w64_msvcr100.exe (EXPERIMENTAL: variant which is linked against MSVCR100.DLL (Visual Studio 2010 runtime) instead of MSVCRT.DLL.) sqliteodbc_dl_msvcr100.exe (EXPERIMENTAL: variant linked against MSVCR100.DLL which needs System.Data.SQLite.dll or sqlite3.dll in the Windows system folder) sqliteodbc_w64_dl_msvcr100.exe (EXPERIMENTAL: variant linked against MSVCR100.DLL which needs System.Data.SQLite.dll or sqlite3.dll in the Windows system folder)
