I'm just moving from mysql, which worked perfectly, to mssql. It's a standard at my company. I'm having trouble when trying to save a survey by clicking "Resume Later" and filling out a name, password, e-mail address ... you know the drill.

Here's the error:

"Unable to insert record into saved_control table where scid is .

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'scid', table 'limesurvey.dbo.lime_saved_control'; column does not allow nulls. INSERT fails."


Sure enough, when I print out my _SESSION array, scid is null. scid is the primary key in lime_saved_control, so it can't be null if you want to save a survey.

So why is it null and how can I get it not to be null in my session?

I've searched the forums, haven't found anything. Thanks.


----------------


My configuration:

$databasetype = "odbc_mssql"; // ADOdb database driver - valid values are mysql, odbc_mssql or postgres
$databaselocation = "<removing real name for security reasons>";
$databasename = "<removing real name for security reasons>"; // The name of the database that we will create
$databaseuser = "lime"; // The name of a user with rights to create db (or if db already exists, then rights within that db)
$databasepass = "<removing real pass for security reasons>";
$dbprefix = "lime_";

Which version and build of LimeSurvey do you use?

I'm using Version 1.71+ (5326)

Plz upgrade to the latest build of LimeSurvey and tell us, if you can reproduce the problem. Carsten Schmitz fixed some MySQL-bugs so far; if the problem still exists ==> fill out a bug report!