how do i retrieve data from SQLite to VB6?
Refer here for the connection string properties: http://www.connectionstrings.com/sqlite
You should also specify the version (3 or 2).
Edit: try to remove: LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0And add the version: version=3If it works, try to add a property at a time until it won't work anymore, to identify the broken property.
These are available connect string options for SQLite3 ODBC Driver
Description=Database=<<file_name>Timeout=StepAPI=0SyncPragma=NoTXN=0ShortNames=0LongNames=0NoCreat=0NoWCHAR=0FKSupport=0LoadExt=I just created a system DSN and looked in registry at HKLM\SOFTWARE\ODBC\ODBC.INI\<<my_dsn_here>>