Using Firebird as the RDBMS

[Papillon]

I do not think it would be less effort with the ODBC code, since even if I can find it, it is hopelessly out out date.
_________________
Papillon

[obsidian-studios]

So basically I need to write a plugin then for Firebird on Linux? Is that how MySQL is currently integrated or is it a part of nwnx on Linux? I looked at some of the code from linux nwnx sources, but not exactly sure what I am looking at yet. Plugin, or tie in code.

Thanks

[NoMercy]

Someone already made some files to get nwnx2 to work with postgres SQL, so it's probably a good idea to look at how they went about it to work out what you'd need to do too:

Two versions, slightly diferent (one I think doesn't use ODBC one does)

http://nwvault.ign.com/Files/other/data/1103224637000.shtml

http://nwvault.ign.com/Files/other/data/1103498875000.shtml

[obsidian-studios]

Thanks I really appreciate it and will do. Still would like to know if the mysql stuff is a plugin or not. Seems as if you have to have mysql installed in order to compile nwnx on linux. Booooh

[NoMercy]

*digs briefly* You know you really should do this yourself if your going to write a plugin (I don't mind since I want to learn all these tricks anyway), yes it looks like its all plugins, which are loaded through dlopen() and only the nwnx_odbc.so plugin conains any linking requirements for libmysqlclient.

[obsidian-studios]

I was more asking per what I am looking at. I am writing code now to provide support for firebird. So far I am not seeing anything ODBC related and looks like MySQL is a plugin. So I guess I am making a plugin for firebird. Got all the bast headers and source files in place and am writing the guts, actual code now. From here on that I guess i will post to sourceforge for q and a while I develop the plugin.

Also not sure where you referring to nwnx_odbc.so on what platform? One of the past links posted? Seems the linux stuff I downloaded has mysql wrapped in and you can't even complie it without mysql installed.

So along with adding support for firebird via a plugin I guess I will also have to modify the make and configure files to either complie support for mysql or firebird?

[NoMercy]

The mysql plugin compiles to the module name nwnx_odbc.so, I guess the name is just a hangover from the original ODBC module on the windows version.

[JeroenB]

Yes, the mysql connection is build in the odbc plugin on Linux. As an idea, you might have a look at how I implemented the multiple database support in the windows version. It should be quit easy to port that to the linux base and add so in a fairly general way the extra firebird support (just an idea )