NWNX ODBC ALPHA released!

[Blacksting]

That would be a no

[Blayde Windwalker]

Dooh, I had been useing MySQL 4.1 which is the recommend release.

As soon as I went back to 4.0 everything went very well.

[JeroenB]

Is someone having any problems with the module? Please state now, so we can finish this project up

Thanks for testing!

[Makzimia De Graf]

Jeroen, I am in the middle of a big change to the way we handle players, and I have not had time to confirm whether or not the issues still remain with your new module. I am anticipating use of it on the test server following this week. It's not a huge task to check once I have time. Please bare with me on this though.

Thanks.

Makz.
_________________
Makzimia De Graf

DM/Creator Island of Fredian
fredian.game-host.org:5123
Forums at http://castille.us/fredian/Forums

[Blacksting]

All seems well. I did encounter a brief period when the odbc module stopped sending response data back completely. The log did not even show "response 0 bytes" but it did log the request. A complete script rebuild with an external compiler (without changing any lines of NWN script mind you) fixed the problem so I am chalking it up to the increasingly unreliable compiler in the toolset. If it happens again I will investigate further.

[Blacksting]

Now that the new odbc source has been released (woohoo!) I will be adding a bit to it for anyone that is interested. A second sql connection will be available to send data to a web site. The ini file can include webip, webuser, webpwd, and webdb lines.

If an SQL query is prefaced with a * (e.g. "*UPDATE blah SET blahvar = 'blah') it will use the web sql connection instead.

If this is interesting to anyone let me know and I will give a link to the expanded dll.

[Papillon]

Cool, a second database connection. FYI, I am planning to integrate multiple database connections into ODBC2 sometime in the (somewhat) near future.
_________________
Papillon

[Blacksting]

Alrighty then If anyone wants this one in the mean time say so. I have to package up the revised odbc.dll and the slightly revised aps_inc (which adds a "Fetch" switch to the NWNX code for fetching web db data.)

[JeroenB]

Sounds interesting! Way to go!

[Manuel]

[Blacksting]

Here is the link to the revised second (web) connection nwnx_odbc.dll.

Revisednwnx_odbc.rar

Read the Information.txt included.

[Senalaya]

JeroenB,

you are a bad boy!

Why does nwnx_odbc (v. 0.92) require the 'libmysql.dll', allthough I use ODBC????

Without the MySQL DLL, the NWNX logfile looked like this:

[JeroenB]

Sorry ,

I can not help it that it needs the libmysql library as it still depends on it why not even use the direct connection type. I will update the manual to note that is a required library.

126: The specified module could not be found.: this is a message generated by the Win32 api. When a load of a DLL fails, NWNX calls the FormatMessage function which produces this message. I can not do anything about that.

btw. Pap noticed this yesterday too

[Senalaya]

Any hint to the MySQL lib along with that error message would have been fine. I hate guessing!

[JeroenB]

Especially for you I have done some work on it and came up with the ideal solution! You don't need the mysql dll file anymore. The plugin is now statically linked to mysql and has no dependencies on seperate file anymore. I hope you like it

You can download the last version (0.9.2.1) from here and throw the libmysql.dll file away from your computer unless you have other plugins that need it .