ODBC official in sqlite, is possible?
(1) By anonymous on 2022-08-12 20:34:18 [link] [source]
ODBC official in sqlite, is possible?
(2) By SeverKetor on 2022-08-12 23:00:05 in reply to 1 [link] [source]
I suspect I'm not alone when I say: I have no idea what you've attempted to ask.
Can you provide any clarification on what you're trying to do/say?
(3) By anonymous on 2022-08-13 05:28:44 in reply to 2 [link] [source]
Hi!
Notes
- ODBC is a protocol that you can use to connect a Microsoft Access database to an external data source such as Microsoft SQL Server.
- currently unofficial sqlite odbc is available here: http://www.ch-werner.de/sqliteodbc/
- https://github.com/sqlite/sqlite
- there is no official sqlite odbc source code, only the unofficial odbc
- have you thought about creating an official odbc for microsoft access/excel ?
(4) By PChemGuy on 2022-08-13 13:37:20 in reply to 2 [link] [source]
Basically, the only open source SQLite ODBC driver has not been updated for two years. This driver is used on Windows for talking to the SQLite library from the VBA environment (for example, from MS Access or Excel). There is another commercial ODBC driver. Personally, I have never tried it and only used the open source one. I suppose the author is wondering if there are any plans for making an official SQLite ODBC driver.
(6.2) By Keith Medcalf (kmedcalf) on 2022-08-13 14:48:11 edited from 6.1 in reply to 4 [link] [source]
the only open source SQLite ODBC driver has not been updated for two years
ODBC (yet more IBM technology that was appropriated by Microsoft -- I am surprised that Microsoft did not make it part of the "Great Xing" -- they could have called it DataX or something equally moronic -- perhaps it was because the appropriation of ODBC from IBM predated the great-Xing) has not changed in more than two years (decades rather, but who is counting).
Why do you think that things which (a) work and (b) do not need to be changed should be updated on a regular basis? For what? To change the colour of the box?
The most stable version of any software is the most recently discontinued and no longer supported version (the one that the manufacturer has stopped farting with). This version has all its (known) bugs fixed and as it works today so it will work tomorrow for all values of today.
(8) By anonymous on 2022-08-14 02:30:39 in reply to 4 [link] [source]
[...] I suppose the author is wondering if there are any plans for making an official SQLite ODBC driver.
- Yeah! exactly what i thought and my doubt... Will there be official SQLite ODBC driver support? (yes or no)
So... have you all (team and/or community SQLite) thought about offering official support?
(9) By Decker (d3x0r) on 2022-08-15 01:50:24 in reply to 8 [source]
from what I've seen No. Heck, in general developers don't even know what ODBC is, and often than I'd expect build their projects against some specific library for a specific database, rather than a more general solution.
But then ODBC doesn't really give any support for wide support - create table statements often have to be customized per database; quoting data between databases often have different requirements.
https://sqlite.org/forum/forumpost/fdb0bb7ad03d6b21 would be one of the features an official driver would need; and there's no interest in supporting anything than a linkable library...
Although there is a .NET provider that seems official https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki (at least is hosted by sqlite)
(5) By Simon Slavin (slavin) on 2022-08-13 13:49:04 in reply to 1 [link] [source]
Only Microsoft can publish an official driver. Microsoft is free to provide one any time it wants. All the details it needs are open source and publicly available. If the development team runs into problems, they can post here and get help and advice.
As for unofficial ODBC drivers …
Free:
http://www.ch-werner.de/sqliteodbc/
Commercial:
(7) By anonymous on 2022-08-13 15:53:55 in reply to 5 [link] [source]
Hi, Publishing ODBC driver is possible by anyone. Look at PostgreSQL and mySQL.
They are making the drivers publicly available from their website...
Thank you.