Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:44275
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.219.214 as permitted sender)
DomainKey-Status: bad
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :cc:content-type:content-transfer-encoding;
        b=hT8bu/VEruIJxPJJYReThRXeLvCfvGH4lxKqoTMW2ACgg43408Pbad7w3O1zw+14hf
         oUUpZKjhc29u+edjqkD5XbeZOs0lvGCy1uAcOKlirPbpPNlO1ya0n0AX7ZQyLuSTBZgn
         inPNtmiQJWO7mh/3DktiX6R3BDit4Da8QTaaM=
MIME-Version: 1.0
In-Reply-To: <200905042127.39595.massi@zend.com>
References: <200905042127.39595.massi@zend.com>
Date: Sun, 14 Jun 2009 11:11:23 -0400
Message-ID: <4e89b4260906140811h538cb5d5p26ca8797dbe4b024@mail.gmail.com>
To: Massimiliano Cavicchioli <massi@zend.com>
Cc: internals@lists.php.net
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Subject: Re: [PHP-DEV] Stored procedure error propagation from MSSQL to PDO
From: kingwez@gmail.com (Wez Furlong)

Use PDO_ODBC and make sure you are running with the most recent
version of FreeTDS and its ODBC driver.

--Wez.

On Mon, May 4, 2009 at 2:27 PM, Massimiliano Cavicchioli<massi@zend.com> wr=
ote:
> =A0Hi all,
> I could not work out a way to make an error occurred on a stored procedur=
e 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
>
>
>
> --
> PHP Internals - PHP Runtime Development Mailing List
> To unsubscribe, visit: http://www.php.net/unsub.php
>