Sql Server stored procedure strikes back
| From: | David V�zquez | Date: | Fri, 24 Nov 2000 08:29:35 +0000 |
| Subject: | Sql Server stored procedure strikes back | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4709@lists.php.net to get a copy of this message | ||
I am trying to execute a sql server stored procedure with the following
code:
MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO
RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");
$query = "execute procedurename parameter1,parameter2";
$result = MSSQL_QUERY($query);
and this is the response,
"Warning: MS SQL message: Could not find stored procedure 'procedurename'.
(severity 16)"
any ideas?
Thanks,
David.