need SQLite3 for a portable program vb6

Question

Is there any idea to use sqlite version 3 in vb6 like sqlite version 1 ? sqlite version 1 use ags_sqlite.dll

http://www.freevbcode.com/imagesvr_ce/184390/source/008/zully_lite_sqlite.zip

Answer 1

I would use the SQLite ODBC driver. It works pretty darn well and allows the DSN-less approach, which makes app distribution easier.

The only to look out for is that it won't allow multiple statements in one call - thus you must call them separately.