An up-to-date SQLite ODBC driver?
(1) By anonymous on 2022-10-19 17:30:05 [link] [source]
Since one of my SQLite db file has been managed by the latest SQLite version (3.39.2), I am no longer able to access the tables through the ODBC driver. There is no error when connecting to the database, but the list of tables remains empty.
I have a suspicion that this is because it is seriously behind, since it's built on version 3.32.3.
Is there any other more recent ODBC driver for SQLite available out there?
(2) By Chris Locke (chrisjlocke1) on 2022-10-19 18:02:24 in reply to 1 [source]
This is more of a question for the ODBC driver support forum, than the SQLite forum.
Is there anything in your database that is relevant to the newer SQLite version? It's possible (as DB Browser for SQLite suffers the same fate) that it has an internal parser and sometimes can't work out the newer schema, fails, and therefore doesn't display anything.
The easiest way to confirm is create a new database in 3.39.2 that's as simple as you can get, see if it works with your driver, then add each table (just the schema - no data) from your 'broken' database to the new database, until you find what table breaks it.
But again, this should be raised with the ODBC driver support team.
(5) By anonymous on 2022-10-19 19:46:31 in reply to 2 [link] [source]
Mostly because I have a view that includes the more recent FULL JOIN.
(3) By Chris Locke (chrisjlocke1) on 2022-10-19 18:03:34 in reply to 1 [link] [source]
What language are you writing in? Does it need to be via ODBC?
(4) By Donald Griggs (dfgriggs) on 2022-10-19 18:18:50 in reply to 1 [link] [source]
Are you using Windows?
I see that Werner's page includes a version that allows you to provide your own DLL file.
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)
Perhaps this helps.
Donald