SqlDbx
You are not logged in.
Pages: 1
Is there a way to connect to a SQLite3 database directly, without the need to define a DSN in the ODBC control panel? The SQLite 3 drive is installed.
I want to work with the .sqlite files in the Firefox profile directory, and I would prefer to connect to them directly with a DSNless syntax, something like "DRIVER=SQLite3 ODBC Driver;Database=<path_to_file>;".
Is there a way to use this syntax to connect to databases via ODBC?
Thanks
Offline
My shame, RTFM! I found some indications in the help file. Setting the driver name in the Options field as "DRIVER=C:\Program Files\SQLite ODBC Driver for Win64\sqlite3odbcnw.dll" and the filename, I was able to connect to the sqlite file.
What are the differences among the various choice I see in the SQLite ODBC Driver folder?
Offline
Pages: 1