Errors connecting to database

[sanchohardbottle]

Can somebody please give me a clue, I load my module using nwnx2 and immediately get this error in the log;

! Error while connecting to database: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
o Got request: select tag,value from ats_data where player='Sancho Hardbottle' and name='Sancho Hardbottle' limit 0,1
! SQL Error: [MySQL][ODBC 3.51 Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
o Sent response (-1 bytes):
o Disconnecting from database.

My nwnx.ini file looks like this;

; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.

[NWNX]
ServerPort = 5121
ModuleName = "A_Test_Mod"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 60
GamespyRetries = 1
OldGamespyProtocol = no
RestartDelay = 10

[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 = nwnuser
;pwd = mypassword
;db = nwn

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

[PROFILER]
MaxLogSize = 512 ; in KByte
LogLevel = 1 ; 1=overall statistics, 2=full script callstack

I'm new to MySQL and NWNX2 so any help would be greatly appreciated.

Thanks, Sancho

[NoMercy]

I'm not overly familair with the error, could you first check youve got the latest version of NWNX installed:

Main program: 2.6.1
ODBC2: 0.9.2.4

[Xildjian]

If you are really using MySQL you need to comment out the sqllite settings and uncomment the mysql settings. the ";" is treated as a comment in a .ini file.
_________________
Member Shadow of Iniquity development team

[sanchohardbottle]

Yes it is v. 2.6.1, I tried changing the ini file to:
; 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 = nwnuser
pwd = mypassword
db = nwn

But I still get the same error message;
Access denied for user 'ODBC'@'localhost' (using password: NO)

[NoMercy]

I didn't spot it mentioned in your post, are you sure you absolutely sure havn't got the old ODBC module in there instead of the ODBC2 beta (version 0.9.2.4) ?

I can't see why if you had ODBC2 with sqlite previously configured that it would ever generate a Access Denied error.

[JeroenB]

It looks like the ODBC driver is being used for database access. This is strange as the new version shouldn't do that. You could try to see if the ODBC driver is correctly configured, just like the configuration in the nwnx2.ini file.

[sanchohardbottle]

The files I downloaded and installed are;

MyODBC-3.51.11-1-win.exe
mysql-essential-4.1.10-win32.msi

along with the Administrator and Browser GUIs
I'll try uninstalling everything, redownloading and reinstalling, got my fingers crossed.

Sancho

[NoMercy]

If your reinstalling just make sure your using this version of the plugin:
http://www.nwnx.org/uploads/media/nwnx_odbc2_0924.zip

You shouln't need MyODBC as the new plugin can access MySQL directly, and hence a little bit faster.