SQLite and ODBC Problems

iXi · 12-02-2005, 05:03 AM

neoxed how do i create the db files thay are req for sqlite.. ODBC driver?..

iXi · 12-02-2005, 08:12 AM

Well i created now sqlite3 invite.db.. with the right tables etc but bot still say missing table.. bla bla

[14:10] [?AlcoBot?] Error :: ModInvite - The database "invite" is missing the "invite_hosts" or "invite_users" table.

www.siteszene.org/invite.db

i hope someone can check but i'm sure the file is OK

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 (").