| View previous topic :: View next topic |
| Author |
Message |
Primogenitor
Joined: 08 Jan 2005
Posts: 88
|
 Posted: Thu Aug 04, 2005 9:38 Post subject: External SQLite access |
 |
|
If I use an external SQLite commandline application, such as 3.2.1 or 3.2.2 @ http://www.sqlite.org/download.html , to modify or create the database then NWNX wont read it any more. Here is a part of the log:
| Code: | NWNX ODBC2 plugin V.0.9.2.4
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org
o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using SQLite connection.
o Hooking SCO....hooked at 5c65d0
o Hooking RCO....hooked at 5c64b0
o Connect successful.
...
...
o Got request: SELECT rowid FROM prc_cached2da_appearance WHERE rowid=1
! SQL Error: file is encrypted or is not a database
o Sent response (0 bytes):
o Got request: INSERT INTO prc_cached2da_appearance (rowid, name) VALUES (1 , 'Character_model')
! SQL Error: file is encrypted or is not a database
o Got request: SELECT race FROM prc_cached2da_appearance WHERE ( rowid = 1 )
! SQL Error: file is encrypted or is not a database
o Sent response (0 bytes):
o Got request: SELECT rowid FROM prc_cached2da_appearance WHERE rowid=1
! SQL Error: file is encrypted or is not a database
o Sent response (0 bytes):
|
Anyone got any ideas? I need to be able to pass an externally generated SQL query into SQLite so that it can precache the 2da files for SELECT queries from within the script. Biowares Get2DAString is too slow to do it in-game. |
|
| Back to top |
|
 |
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Thu Aug 04, 2005 19:53 Post subject: |
|
|
ODBC2 currently uses SQLite 3.0.8, so you should try a command line utility with the same version.
_________________
Papillon |
|
| Back to top |
|
|
Primogenitor
Joined: 08 Jan 2005
Posts: 88
|
| Posted: Fri Aug 05, 2005 9:43 Post subject: |
|
|
| Ah, that would explain it. There are no plans to update it are there? |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Sat Aug 06, 2005 9:26 Post subject: |
|
|
I guess I will add the current version to the next release of ODBC2, but I am not sure when that will be.
_________________
Papillon |
|
| Back to top |
|
|
Primogenitor
Joined: 08 Jan 2005
Posts: 88
|
| Posted: Sat Aug 06, 2005 10:22 Post subject: |
|
|
Ive looked into this some more, and theres good and bad news.
Good News: SQLite uses a public accessible CVS storage, so I can get the source code from a 3.0.8 version without too much trouble. 
Bad News: I have no idea how to go about recompiling the CVS sources. There is a "How To Compile" section on the sqlite wesbite, http://www.sqlite.org/cvstrac/wiki?p=HowToCompile, but I am a real novice when it comes to compiling these things. I think I can do it with DJGPP or mingw but I havnt had much luck so far  |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
|
| Back to top |
|
|
Primogenitor
Joined: 08 Jan 2005
Posts: 88
|
| Posted: Mon Aug 08, 2005 6:41 Post subject: |
|
|
Oh, its not a problem getting some program to access the database, nor is it a problem getting something to run the SQL. The problem is trying to do it in an automatic way that requires no end-user intervention.
Its for the PRC server pack http://nwvault.ign.com/View.php?view=Other.Detail&id=945 |
|
| Back to top |
|
|
Primogenitor
Joined: 08 Jan 2005
Posts: 88
|
| Posted: Mon Aug 08, 2005 18:11 Post subject: |
|
|
Okay, my mistake. I was using v2 SQLite.exe because I had assumed that the download at the top of the list would be the most recent version.
Nothing to see here, move along..... |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
