Fwd: [PHP] PDO mssql + multiple rowsets

btw... the bug: http://pecl.php.net/bugs/bug.php?id=10530 ---------- Forwarded message ---------- From: Javier Ruiz <jruizmail@gmail.com> Date: Apr 4, 2007 9:10 AM Subject: Fwd: [PHP] PDO mssql + multiple rowsets To: php-general@lists.php.net I've seen there's an open bug on the missing feature I pointed out in my first email, but it's even not assigned and I cannot get an answer from the developer... so... does anybody know if there is any plan to finish the PDO-dblib driver? TIA ---------- Forwarded message ---------- From: Javier Ruiz <jruizmail@gmail.com> Date: Apr 2, 2007 9:54 AM Subject: Re: [PHP] PDO mssql + multiple rowsets To: "Frank M. Kromann" <frank@kromann.info>, < php-general@lists.php.net> Hi again. Sorry I was out of my city during the weekend and had no connection available... So Frank, please lemme know, is the feature (multiple rowsets) planned to be included in the pdo-dblib driver? I would like to know to include or not pdo in my development needs against mssql. Thanks, greetings! On 3/29/07, Frank M. Kromann < frank@kromann.info> wrote:

It Is doable. The native mssql/dblib extension does support that features. I just have'nt had the time to code it for pdo_dblib. - Frank I too have been having problems getting the PDO dblib for mssql to play well (getting the same error actually). If you find a reason or work around for it I would appreciate hearing about it. Thinking of going the odbc route myself if I can't get it to work. Respectfully, Ligaya Turmelle -----Original Message----- From: Javier Ruiz [mailto: jruizmail@gmail.com] Sent: Wednesday, March 28, 2007 8:21 PM To: php-general@lists.php.net Subject: [PHP] PDO mssql + multiple rowsets Hi! I want to use PDO in my apps for connecting to several RDBSs, one of them, sql server 2000 and 2005. I tried to use as DSN something like "mssql:..." (as I've seen in the php manual pages) but I get a PDOException with the message "Unable to open PDO connection [wrapped: could not find driver]". I can work well with the mssql built-in functions (like mssql_connect, mssql_query and so on...) and even I can almost work perfectly using in my dsn "dblib:...". So first question: is the PDO's driver "mssql" deprecated or is it me doing something wrong in the PHP installation? BTW, I use php-5.2.1 In case that the answer to the first question is that "mssql" is no more used as a PDO driver, I have a problem... I have stored procedures in sql server that return multiple rowsets, I've seen that PDO offers functionability to manage this, but not for the dblib driver... if I try to use the $stmt->nextRowSet() method, I get an exception like "Driver does not support this function: driver does not support multiple rowsets" What can I do then to work with my stored procs? Thanks in advance -- PHP General Mailing List ( http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php