problem running stored MsSQL procedure
| From: | Pepu | Date: | Wed, 11 Jul 2001 08:30:57 +0000 |
| Subject: | problem running stored MsSQL procedure | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-general+get-57318@lists.php.net to get a copy of this message | ||
a very simple code in PHP:
$cs = odbc_connect("db", "me", "pass");
$zumzum=odbc_exec($cs,"wf_test");
---------
with corresponding stored procedure in MS SQL:
CREATE PROCEDURE [wf_test]
as
print 'BLABLABLA'
return
GO
---------
results with a following error message:
Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not
find stored procedure 'wf_test'., SQL state 37000 in SQLExecDirect in
xxx.php on line 27
(note: the connection is realised through ODBC)
changing odbc_exec to odbc_do gives nothing just as replacing "wf_test" with
"wf_test()"...
also typing "exec wf_test" or "execute wf_test"
(e.g. explicitly telling sql to execute the script) doesnt give anything
any ideas/suggestions very awaited :)
---
This message contains no viruses.
Guaranteed by Kaspersky Anti-Virus.
www.antivirus.lv