SQLServer 2.0

[Gryphyn]

SQLServer plugin

Well it's here... a SQLServer 2.0 plugin for NWNX^2

There has been some major rework of the back-end hence the separate plugin, and not an extra option for the existing ODBC plugin.

I think the major 'usability' improvement, that you'll all love is the removal of all the SQL syntax string manipulation. It's still here, but you have an alternative where it's not required.

Introducing Parameters. Add a parameter indicator ('?') to your SQL Statement and this will be replaced by the value of a SQLBind...() function.

SQLPrepare("{call [stored_proc] (?)}");
// or SQLPrepare("select value from table where key=?");
SQLBindString("MyKey");

Note the new function SQLPrepare(), allows us to SQLBind...() variables, in sequence, before we SQLExecute(). If you are using parameters you must SQLPrepare() the SQL command first. Your SQL will be easier to write AND much easier to read.

Technically we've added 'usability' to Objects. Objects and other data types can now be returned in the same result set. No need for a separate query to get the Object data.

int i = SQLGetInt(1);
object o = SQLGetObject(2);
string s = SQLGetString(3);

will all work from the same result-set (*columns must be accessed in sequence)

With the improvements to Object fetching, I no longer needed this - but I left it in, MARS - Multiple ACTIVE result sets. You can now have up to 4 active result sets. A new command SQLContext() enables you to switch between each 'context' to use the results of one as in 'input' for another, without destroying the original.

Getting into trouble? Full ODBC diagnostics are added into the log file, to assist with those queries that 'break' on you

You get all this and more...
(but only with SQLServer 2005 or better - defaulting to the EXPRESS editions *the free ones)
at the give-away price of - Oh yeah I'm giving it away!

Advances in 2.0
* Native Client support
the .ini now accepts a 'nativeclient' value 2005(default) or 2008 for the SQLServer version being used.
* Object Parameter improvements.
SQLGetObject() & SQLSetObject() are no longer constrained to the final parameter, and the 1 object limit has been removed. So multiple 'object columns' can be bound in the same SQL statement. eg
SQLPrepare("update table set obj1=?, obj2=? where key=?");
SQLBindObject(oItem1);
SQLBindObject(oItem2);
SQLBindString("KeyToRow");
SQLExecute();

Cheers
Gryphyn

PS. Compiled on VistaUltimate SP1 using VisualStudio2008.
The source is available

[Ed: Sorry I couldn't update the text on my contributions page, don't know why not. At any rate the SQLServer 2.0 project is now available]

[RamaDeveloper]

Hello again, I finally got some free time to download the plugin you generously provide and have loaded up the source but find that I have no NWNXBase.cpp file, I've had a dig around the forums but can't find it elsewhere, would it be possible to get hold of a copy or a paste of the source ?

Cheers, Chris
_________________
Chris

[Gryphyn]

[MaxRock]

I've been toying with the idea of switching our PW from mysql to sqlserver, mainly because of the stored proc and multiple record sets functionality, and finally got a little test module up (no other scripts except the sqlserver() for modload and the test script; no other nwnx plugins loaded

all the test script does is

[Gryphyn]

[MaxRock]

The new syntax works just fine.

I only had the SQLExecute(...) line.
Apparently running two of those without fetch and/or commit takes the server down.

Thank you for your help

[Gryphyn]

[MaxRock]

In case it helps any:
I'm using the express 2008 version on xp 32 sp3