SQLServer

lostdreamz · Joined: 19 Nov 2006 Posts: 26

Putting SQLExecDirect("COMMIT") into the on module load made no difference at all. The database is still locked and the select statements are hours out of date.

Gryphyn · Joined: 20 Jan 2005 Posts: 431

lostdreamz · Joined: 19 Nov 2006 Posts: 26

Thanks thats what I needed to know =)

Gryphyn · Joined: 20 Jan 2005 Posts: 431

Gryphyn · Joined: 20 Jan 2005 Posts: 431

It's here NWNX4 SQLServer plug-in

This will get you started with SQLServer or SQLServer-Express.
The Express version being the default.

Standard "sql_include" functionality is provided.
Read the contribution notes.

Cheers
Gryphyn

Balo · Joined: 12 May 2007 Posts: 4

Papillon · x-man Joined: 28 Dec 2004 Posts: 1060 Location: Germany

Please post the contents of nwnx.txt after launching it with the sql server plugin enabled.
_________________
Papillon

Gryphyn · Joined: 20 Jan 2005 Posts: 431

You could also try looking for a .log file (rather than .txt)

Cheers
Gryphyn

krazzybone · Joined: 17 Jul 2008 Posts: 2

Im totally lost as to where these files get unzipped to, and everytime I try to edit xp_sqlserver.ini, i get errors it says its read only

// xp_sqlserver.txt

NWNX SQLServer Plugin V.106.108.0.9 (CTP)
(c) 2007 by Rob Lobbe (Gryphyn)
visit us at http://www.nwnx.org

* Log level set to 2 (everything)
Instance: .\SQLEXPRESS
Database: NeverwinterNights2
Trusted connection
! [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
* Connection to SQLServer failed!

//NWNX4

2:47:03 PM: Running in GUI mode.
2:47:03 PM: Worker thread started.
2:47:03 PM: Starting the NWN Server.
2:47:08 PM: * Hook installed and initialized succesfully

// xp_sqlite.txt

NWNX SQLite Plugin V.0.0.8
(c) 2007 by Ingmar Stieger (Papillon)
visit us at http://www.nwnx.org
(built using SQLite 3.3.17)

* Log level set to 2 (everything)
* SQLite database file is C:\NWNX4\sqlite.db
* Plugin initialized.
* Registering under function class SQL

// NWNX.txt

NWN Extender 4 V.0.0.8
(c) 2007 by Ingmar Stieger (Papillon)
visit us at http://www.nwnx.org

* Loading plugins...
* Loading plugin xp_sqlite.dll: Successfully registered as class: SQL
* Loading plugin xp_sqlserver.dll: Error during plugin initialization.
* Loading plugin xp_time.dll: Successfully registered as class: TIME
* Disabling general protection fault error dialog.
* NWNX4 activated.

Theres all the info as I am not so good at explaining really what is happening hehe. thanks for any help.

Gryphyn · Joined: 20 Jan 2005 Posts: 431

Gryphyn · Joined: 20 Jan 2005 Posts: 431

SQLServer plugin

Well it's here... a SQLServer 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. Wink

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)

NB: A special exception exists for SQLBindObject(). You can only bind one object per SQL statement and it MUST be the last parameter. Hint: adding Object data is best done via a stored procedure.

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 Wink

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!

Cheers
Gryphyn

PS. Compiled on VistaUltimate SP1 using VisualStudio2008.
I'll release the source once NWNX^2 goes semi-final for NWN1.69 Cool

Gryphyn · Joined: 20 Jan 2005 Posts: 431

I'm assuming this is still a solo project...
but anyone wanting an update for SQLServer 2008 (I've added the new SQLServer 2008 Native Client) send me a PM and I'll send you an update.
(still clocking in at about 5~10 times faster than the MySQL plugin)

Cheers
Gryphyn

[Ed. this ones the NWN1 SQLServer plugin]

chris421 · Joined: 07 Apr 2005 Posts: 53

Pulled down the binary from your contributions page.

virusman · Joined: 30 Jan 2005 Posts: 1020 Location: Russia

Gryphyn · Joined: 20 Jan 2005 Posts: 431

There are two versions...
The current one is for NWNX2. (NWN1)
There is an older proof-of-concept one for NWNX4 (NWN2)

**Make sure you've got the right one.

--I'm currently working on bringing the NWNX4 one in-line with the NWNX2 one, as I've grown accustom to the easier coding requirements (than offered by the NWNX base/core.)

I have a new job, so finding time is a bit more difficult at the moment.

Cheers
Gryphyn

The NWNX Community Forum