FlashFXP Forums - View Single Post

neoxed · 12-03-2005, 08:00 PM

I tested the SQLite ODBC Driver and it works fine, although there are a few catches in getting it all setup. The SQLite ODBC Driver is built against SQLite v3.0.7, so you must create the database with a SQLite command-line utility of the same version.

Download and install the SQLite ODBC Driver.
Download and unpack the SQLite v3.0.7 command-line utility.
Create a database: sqlite3.exe invite.db
Import the table schema: .read invite.sql
Create a ODBC System DSN for the database file using the SQLite3 driver.

You will have to edit the invite.sql file before executing it, since SQL syntax varies between implementations. Remove the comments at the beginning of the file (they start with a hash, #) and replace all grave accents (`) with quotation marks (").

12-03-2005, 08:00 PM
neoxed Too much time... Join Date: May 2003 Posts: 1,326	I tested the SQLite ODBC Driver and it works fine, although there are a few catches in getting it all setup. The SQLite ODBC Driver is built against SQLite v3.0.7, so you must create the database with a SQLite command-line utility of the same version. Download and install the SQLite ODBC Driver. Download and unpack the SQLite v3.0.7 command-line utility. Create a database: sqlite3.exe invite.db Import the table schema: .read invite.sql Create a ODBC System DSN for the database file using the SQLite3 driver. You will have to edit the invite.sql file before executing it, since SQL syntax varies between implementations. Remove the comments at the beginning of the file (they start with a hash, #) and replace all grave accents (`) with quotation marks (").