Page 1 of 1

Hi y'all!!

Posted: Mon Dec 12, 2005 2:09 pm
by farid
I hope someone can help me, I have a connection to a stored procedure and suddenly has stopped working I don't know whats wrong, it appears the following warnings:

Warning: mssql_execute(): message: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. (severity 16) in D:\inetpub\InetGREGION9\php\fichas\test_erase.php on line 17

Warning: mssql_execute(): stored procedure execution failed in D:\inetpub\InetGREGION9\php\fichas\test_erase.php on line 17

Warning: mssql_fetch_row(): supplied argument is not a valid MS SQL-result resource in D:\inetpub\InetGREGION9\php\fichas\test_erase.php on line 19

And my code is:

Code: Select all

$folio_reclamante="901104645139";
 $conn=mssql_connect("$IP", "$USER", "$PASSW") or die("Couldn't connect");
 			  
 $base=mssql_select_db("smsdb", $conn) or die ("Couldn“t connect");
 $stmt=mssql_init("sp_fichasEstrategiasCom", $conn);
 $value = $folio_reclamante;
 mssql_bind($stmt, "@folio", $value, SQLVARCHAR, false, true, 100);

 $result = mssql_execute($stmt);
  
 while ($arr=mssql_fetch_row($result))
  	echo $arr[0];
unset($stmt);
mssql_close($conn);

Posted: Tue Dec 13, 2005 1:00 am
by m3mn0n
Thread moved to the Databases forum.