Stored procedure error propagation from MSSQL to PDO
| From: | Massimiliano Cavicchioli | Date: | Mon, 04 May 2009 18:27:39 +0000 |
| Subject: | Stored procedure error propagation from MSSQL to PDO | ||
| Groups: | php.internals | ||
| Request: | Send a blank email to internals+get-43852@lists.php.net to get a copy of this message | ||
Hi all,
I could not work out a way to make an error occurred on a stored procedure on
on MSSQL server (2005) propagate back into PHP using PDO and PDOStatement.
My setup is the following:
PHP 5.2.9 / PDO_DBLIB running on a CentOS 5.3 machine executing the most
simple stored procedure on a MSSQL Server 2005 that only does RAISERROR().
Sample PHP code is attached.
Can anyone address me to a best practices tutorial regarding this case?
Thanks in advance,
Massi.
Massimiliano Cavicchioli
Senior Support Engineer
Zend Technologies, Ltd.
Email:massi@zend.com
Tel:+972.3.6139544
www.zend.com
Attachment: [application/x-php] mssql_test.php
Attachment: [application/x-php] mssql_test.php