Using SQLITE with VB6
I've been working on a VB6 app with SQLite for a while and I've tried a couple of methods of connecting.
So let me summarize and give, what in my opinion is, the best answer.
Methods mentioned by Ben Hoffstein, gobansaor and David W. Fenton are good, but they rely on proprietary interfaces to sqlite.
OLEDB provider by CherryCity is good because it's using a standard interface, but they have a per installation royalty system, which makes it really, really expensive. And their website does not state upfront that the product has royalties. You only find out when you actually bought the product for development and want to distribute it.
Finally there is the absolutely free as in both beer and speech, SQLite ODBC driver at http://www.ch-werner.de/sqliteodbc/ . It works pretty well and I haven't encountered any major issues just yet. The only minor issue I've encountered is that it won't allow multiple statements in one call, so you just have to separate it. In addition, the driver allows the DSN-less approach, which makes everything so much easier.
So, imo, the ODBC driver is really the best solution.
Or try DHSqlite http://www.thecommon.net/2.html from Datenhaus..
"...developed as a fast alternativeto ADO, encapsulating the super-fast SQLite-engine..."
"...With only two Dlls you get a complete Replacement to the whole ADO/JET-environment - no dependency-hazzle anymore..."
..it's free (but not opensource).
Here is a link with code examples: