Go Back   FlashFXP Forums > > > >

NeoXed's scripts nxAutoNuke, nxTools, etc.

Thread Tools Rate Thread Display Modes
Old 12-02-2005, 05:03 AM   #1
Senior Member
ioFTPD Foundation User
Join Date: Nov 2002
Posts: 220

neoxed how do i create the db files thay are req for sqlite.. ODBC driver?..
iXi is offline   Reply With Quote
Old 12-02-2005, 08:12 AM   #2
Senior Member
ioFTPD Foundation User
Join Date: Nov 2002
Posts: 220

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.


i hope someone can check but i'm sure the file is OK
iXi is offline   Reply With Quote
Old 12-03-2005, 08:00 PM   #3
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
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.
  1. Download and install the SQLite ODBC Driver.
  2. Download and unpack the SQLite v3.0.7 command-line utility.
  3. Create a database: sqlite3.exe invite.db
  4. Import the table schema: .read invite.sql
  5. 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 (").
neoxed is offline   Reply With Quote

files, odbc, req, sqlite, thay

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

All times are GMT -5. The time now is 10:06 AM.

Parts of this site powered by vBulletin Mods & Addons from DragonByte Technologies Ltd. (Details)