Alot of questions

[Peskyone]

These are the new errors i am getting:

* An error occured during OnCreate of odbc

and

o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using ODBC connection.
o Hooking SCO....hooked at 5c65d0
o Hooking RCO....hooked at 5c64b0
! Error while connecting to database: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
o Got request: SELECT * FROM teleport WHERE Target = 'Fields' LIMIT 1;
! SQL Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
o Disconnecting from database.


unfortunatly i have very little to no clue what it means

[Papillon]

"Data source name not found and no default driver specified" means that you set up the ODBC plugin of NWNX to use the ODBC connection type (check nwnx.ini how to configure that). It expects a data source called NWN in the default configuration, so you'd have to set that up in the Windows control panel.

I would rather use the direct MySQL connection or the easiest option: SQLite. ODBC is fine though.
_________________
Papillon

[Primogenitor]

SQLite is by far the easiest database option, particularly if your not sure what your doing. No passwords, no connections, no other applications to deal with. You dont even have to change the settings to enable it, since its the default. All the SQL syntax it recognises is documented at www.sqlite.org

[Peskyone]

Right but the script is set to use mysql and I don't know how to modify and I have been over the info at http://www.nwnx.org/index.php?id=doc_odbc2 many many times...


Can we please start at the begining I really am a novice with little funds to hire a pro for a for fun server that is already coming out of my pocket. and I know I can do this I just need some help and a few basic questions answered in very plain manner.

1. If the script which I posted perviosly points to Mysql can I even use sqlite as you suggest?

2. If so I understand to download and get a working copy of mysql but please please please no one seems to answer this straight out...NWNX says to make a database but no where...WHERE does it go? In NWN folder..in the game scripts where? If so how? How do I make a database I have tried I have this in the mod in the scripts compiled but is that where the table goes? In the mod?
#include "aps_include"

void main()
{

SQLExecDirect("CREATE TABLE teleport(" +
"Id INTEGER( 10 ) UNSIGNED AUTO_INCREMENT PRIMARY KEY," +
"Spoken CHAR( 20 ) NOT NULL DEFAULT ''," +
"Target CHAR( 50 ) NOT NULL," +
"Familiarity CHAR( 20 ) NOT NULL," +
"FQHN CHAR( 255 ) NOT NULL DEFAULT 'localhost.localnet'," +
"Password CHAR(20) NOT NULL DEFAULT ''," +
"Direction ENUM ( 'None', 'Both', 'In', 'Out' ) NOT NULL DEFAULT 'Both'," +
"Random ENUM ( 'None', 'Both', 'In', 'Out' ) NOT NULL DEFAULT 'None';");
}
or am I doing it wrong?

Where does the 2da adapted database go...It was previously said i can't just make a text file and save it as a database so how do i make a database file? I tried using the tools connected to and i got a sql script file not a database file..are they the same thing? Please *begs* I am really confused at this point. I have tried my best to do all that was suggest and it still doesn't work. If I purged it all and sterted again could someone point me to a beginner walk through on databases,,tables and where the heck they go and how to make them?...Sorry getting a bit fustrated now on week three of 10 hour days of trying to make this work.

[Peskyone]

Even the name of a good book for this I am more then willing to do the work on learning I just need to be pointed the right way.

[Acrodania]