SCO/RCO on MS-SQL Server 2008

[Axe Murderer]

Can't get SetPersistentObject to work on this platform.

I'm Sending the following SQL statement to the hook when SPO is called:
INSERT INTO ObjCampaign (player,tag,name,val,expire) VALUES( 'Axe Murderer','Unknown','MyChest', %s,0 ) val=%s;

The hook is sending the following to SQL Server:
INSERT INTO ObjCampaign (player,tag,name,val,expire) VALUES( 'Axe Murderer','Unknown','MyChest', ~s,0 ) val=~s;

No error is being reported in the nwnx_odbc.txt log file.
Nothing is getting entered into the table.

Table is created using this:
CREATE TABLE ObjCampaign ( player varchar(256) NOT NULL, tag varchar(256) NULL DEFAULT NULL, name varchar(256) NOT NULL, val text NULL DEFAULT NULL, expire int NOT NULL DEFAULT 0 );

I'm thinking the %s --> ~s business is not valid syntax on this platform.

Anybody know?

[Baaleos]

it looks like the hook it replacing the % 'a sql wildcard' with ~, perhaps it thinks you left it in by mistake, and is an unintentional special character?