Hi y'all!!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
farid
Forum Commoner
Posts: 54
Joined: Thu Nov 11, 2004 4:20 pm
Location: Mexico

Hi y'all!!

Post 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);
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

Thread moved to the Databases forum.
Post Reply