Hi y'all!!
Posted: Mon Dec 12, 2005 2:09 pm
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:
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);