NWNx2/OdbC2

[djesiret]

I am having a problem setting up the database.

Windows 2000
wishing to use the internal database.

When I read this from the tutorial:
"The internal NWNX ODBC2 database is based on SQLite v3, which is a fast SQL compliant database that developers can package with their applications - and that is what we did !"

I assumed that after I had placed the files properly and set up the INI (which is set to use the sqlite db as default) then I would be in like sin.

Well I get no response from the test module. Can someone tell me what's up.

A couple of things from the error log.
--------------
nwnx.txt
* Loading plugins...
* An error occured during OnCreate of odbc
* NWNX2 activated.
* NWNX2 shutting down... ;doesn't shut down until I tell it too.. everything runs fine just the db isn't working
* NWNX2 shutdown successfull.

;Here's the kicker
--------------
nwn_odbc.txt
! Error while connecting to database: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
o Got request: DROP TABLE pwdata
! SQL Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
o Got request: CREATE TABLE pwdata (player text(64),tag text(64),name text(64),val memo,expire text(4),last date)

and it rinses and repeats that for the most part.

IS there a service I should have running as a part of this "built in" database? Something in windows? I have ended many of my uneeded services upon install.

would it be best if I set it up with another, on of the external database.

Also I would like to mention that I have no sqliute.db file. Should I have?

The tutorial says in reguards to creating the tables (which I also have no idea how to do):
" If you are using the internal database, all tables have already been created for you (in the file sqlite.db)."

I have no file sqlite.db.

I downloaded and have tried the ver from nwnvault, and two of these from this website.. a v254 which I think is not odbc2.. and a beta 0921 which I think, looking at it documentation that it is odbc2.

I just want something that will restart my mod and store and recall simple var.

[NoMercy]

You seem to be loading the ODBC driver, not the SQLite internal database, check your nwnx.ini file inside your nwn folder contains the following lines:

[djesiret]

[ODBC2]
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 2 ; 0=nothing, 1=only errors, 2=everything

; Use these two settings for the SQLite internal database
source = sqlite
file = sqlite.db

; Use these two settings for ODBC connections
;source = odbc
;dsn = nwn

; Use these five settings for MySQL connections
;source = mysql
;server = localhost
;user = nwn
;pwd = nwn
;db = nwn

; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco = true

my ini file is set up to load the internal database.

I've noticed everone is using MySQL. Has anyone had any sucess with th internal database?

[Papillon]

Which version is your nwnx_odbc.dll file ? It should at least be 0.9.2.
_________________
Papillon

[djesiret]

That's what it was, Papillon. I was using the dll from another ver of the d/l, maybe the NWvault d/l. neway, thanks.. loaded up the test module and got the return on the stored value.

whooo I am sooo excited

[NoMercy]

*rushes in with a seditive*