Skip to Content.
Sympa Menu

freetds - IDENTITY_INSERT ON

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: exxs - matevz sernc <mail AT euhost.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: IDENTITY_INSERT ON
  • Date: Wed, 11 Oct 2000 15:29:32 +0200


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






Archive powered by MHonArc 2.6.24.

Top of Page