SQL Server

[lostdreamz]

I am using SQL Server. The first thing I had to change the create table definition to.

SQLExecDirect("CREATE TABLE pwobjdata (player varchar(64) NOT NULL default '~',"+
"tag varchar(64) NOT NULL default '~',"+
"name varchar(64) NOT NULL default '~',"+
"val text,"+
"expire int default NULL,"+
"last datetime NOT NULL default CURRENT_TIMESTAMP,"+
"PRIMARY KEY (player,tag,name))");

This looks similar apart from the 'last' field which I changed from timestamp as default on timestamp is invalid. Also int(11) isinavlid so I changed this to int. Finally I changed blob to text not sure if this is right.

The first test in the sample mod worked fine the second one gives.

INSERT INTO pwobjdata (player,tag,name,val,expire) VALUES('~','Chest1','Item_0',~s,0)

~s is not valid for text so the insert fails. Can you tell me what I need to do.

Thanks =)

[Papillon]

Are you using the function in aps_demo ? Since the statement should be slightly different:

[lostdreamz]

Yes I havnt changed anything from the demo mod that is what gets printed out in the odbc log as the query that was sent to the database. It loks like the %s is being changed to ~s somehow. Not sure what to do.

[lostdreamz]

Myabe this is just a problem with the ODBC plugin. I am not sure why or how but now the rows are populated with data. Unfortunately the get still fails since the size of the blob is > 1048576 bytes. I will try setting it to varchar(1048576)

[lostdreamz]

o Got request (scorco): SELECT val FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_0'
! SQL Error: Critical error - object too large (>1048576 bytes).

! SQL Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The size (1048576) given to the column 'val' exceeds the maximum allowed for any data type (8000).

arghh I am so cofused now tried setting this to varchar(8000) and now I dont get any rows again

[lostdreamz]

The insert doesnt work unless you specify image datatype for val and if you do you get the size error. There must be a solution

[Gryphyn]

[lostdreamz]

Thank you I will try that. Actually I am trying this on my persistent world with NWN before creating a new persistent world on NWN 2. I reasoned if I got it working with NWN 1 first I would have more success with NWN 2.

I appreciate the fact that you do care for the people who use your software. Its nice to get such helpful replies. Is there any ETA for ODBC or SQLServer support for NWN 2.

[lostdreamz]

Thank you, thank you, thank you so much

For anyone like me who uses SqlServer this is the create table statement that actually works for persistent objects.

SQLExecDirect("CREATE TABLE pwobjdata (player varchar(64) NOT NULL default '~',"+
"tag varchar(64) NOT NULL default '~',"+
"name varchar(64) NOT NULL default '~',"+
"val varbinary(8000),"+
"expire int default NULL,"+
"last datetime NOT NULL default CURRENT_TIMESTAMP,"+
"PRIMARY KEY (player,tag,name))");

Rebecca Casidy (owner - World of Desire PW)

[Gryphyn]

[Gryphyn]