note 11238 added to odbc_connect
| From: | r_vitalijs at mail dot lv | Date: | Mon, 12 Feb 2001 12:00:57 +0000 |
| Subject: | note 11238 added to odbc_connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-10944@lists.php.net to get a copy of this message | ||
HELP HELP HELP!!!!!!!!
How I can return rows using stored procedures in MS SQL SERVER 7.0.
Thise return result : No rows found
$sql="EXEC sp_Selt";
if ($conn_id=odbc_connect("$dsn","","",SQL_CUR_USE_ODBC))
{
echo "<p> connected to DSN: $dsn </p>";
if($result=odbc_do($conn_id, $sql))
{
echo " <p>executing '$sql' </p>";
echo "Results: ";
odbc_result_all($result);
echo "<p>freeing result</p>";
odbc_free_result($result);
}
else
{
echo "<p>can not execute '$sql' </p> ";
}
echo "<p>closing connection $conn_id /p<>";
odbc_close($conn_id);
}
else
{
echo "can not connect to DSN: $dsn ";
}
http://www.php.net/manual/en/function.odbc-connect.php