btw... the bug: http://pecl.php.net/bugs/bug.php?id=10530 ---------- Forwarded message ---------- From: Javier Ruiz <jruizmail@xxxxxxxxx> Date: Apr 4, 2007 9:10 AM Subject: Fwd: PDO mssql + multiple rowsets To: php-general@xxxxxxxxxxxxx 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@xxxxxxxxx> Date: Apr 2, 2007 9:54 AM Subject: Re: PDO mssql + multiple rowsets To: "Frank M. Kromann" <frank@xxxxxxxxxxxx>, < php-general@xxxxxxxxxxxxx> 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@xxxxxxxxxxxx> 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@xxxxxxxxx] > Sent: Wednesday, March 28, 2007 8:21 PM > To: php-general@xxxxxxxxxxxxx > Subject: 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 >
