NWNX Windows Problem

[Zycor]

Here is my error during testing the APS_DEMO mod. This cam outta the log file.

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 ODBC connection.
o Hooking SCO....hooked at 5c4320
o Hooking RCO....hooked at 5c4200
o Connect successful.
o Got request: DROP TABLE pwdata
o Got request: CREATE TABLE pwdata (player varchar(64) NOT NULL default '~',tag varchar(64) NOT NULL default '~',name varchar(64) NOT NULL default '~',val text,expire int(11) default NULL,last timestamp NOT NULL default current_timestamp,PRIMARY KEY (player,tag,name))
! SQL Error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
o Disconnecting from database.

I am using a MS Access database. HELP

[Papillon]

The default CREATE statement in the aps_demo module has been crafted for MySQL. I am sure you should be able to find the correct statement for Access somewhere on these boards, if not, maybe someone can post an example below.
_________________
Papillon

[Zycor]

Is MySQL on windows a common database for NWN? Is this a better choice?

[Papillon]

As easy as Access but better suited would be the SQLite option, which also requires no installation. If you want to support multiple servers or just like MySQL better, than take it, since its the most used database for NWN servers.
_________________
Papillon