Go Back   FlashFXP Forums > > > >

NeoXed's scripts nxAutoNuke, nxTools, etc.

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

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
iXi
Senior Member
ioFTPD Foundation User
 
Join Date: Nov 2002
Posts: 220
Default

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
iXi is offline   Reply With Quote
Old 12-03-2005, 08:00 PM   #3
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default

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
Reply

Tags
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:32 PM.

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