FreeTDS Development Group

[exxs - matevz sernc <mail AT euhost.com>]

Hi,

i have successfully compiled
the current freetds snapshot with --enable-dbmfix --with-tdsver=4.2
on redhat linux 6.2 with php 4.0.2 --with-sybase

and am connecting to MSSQL 7.0 SP1
SELECT's seem to work correctly.

but i receive following error with INSERT. How can i set "IDENTITY_INSERT 
OFF" via TDS ?


Warning: Sybase error: Cannot insert explicit value for identity column in 
table 'Adresse' when IDENTITY_INSERT is set to OFF. (severity 16) in 
/home/www/freedomland/mssql2.php on line 17
result = 1

when executing following script:

<?
$servername="xxx.xxx.xxx.xxx";
$user="xxx";
$password="xxx";
$database="db";

$sqlcon = mssql_connect($servername, $user, $password);
mssql_select_db($database, $sqlcon);

$query="INSERT INTO adresse (KD_Id, Lieferadresse) VALUES('5','test')";
$junk=mssql_query($query);
echo "\n result = $junk \n\n";
?>

ciao
matevz sernc