Bug #72488 [Opn]: PDO Dblib doesn't work with multiple rowsets
Edit report at https://bugs.php.net/bug.php?id=72488&edit=1
ID: 72488
Updated by: adambaratz@php.net
Reported by: jamesking56 at me dot com
Summary: PDO Dblib doesn't work with multiple rowsets
Status: Open
Type: Bug
Package: PDO DBlib
Operating System: Centos 7
PHP Version: 5.6.23
Block user comment: N
Private report: N
New Comment:
I've successfully run queries that produce multiple rowsets. There's also a test that
should cover this case:
https://github.com/php/php-src/blob/master/ext/pdo_dblib/tests/bug_68957.phpt
Sometimes dbresults() errors occur when there's an issue with the query itself. Do you have any
more details on the query itself?
Alternatively, you could test this statement:
'SELECT 1; SELECT 2; SELECT 3;'
Previous Comments:
------------------------------------------------------------------------
[2016-06-24 13:55:42] jamesking56 at me dot com
Description:
------------
When I call an MSSQL stored procedure using PDO DBLIB that returns multiple rowsets, When I request
the next row set, PDO throws an exception.
The same query using sqlsrv in a Windows environment works as normal.
Test script:
---------------
<?php
$pdo = new PDO('dblib:server=example.com,dbname=db1', 'user',
'password');
$stmt = $pdo->prepare('EXEC [dbo].[spProcedure] ?,?,?');
$stmt->bindParam(1, 'test');
$stmt->bindParam(2, 'test');
$stmt->bindParam(3, 'test');
$stmt->execute();
$result = $stmt->fetch();
$stmt->nextRowset();
$result2 = $stmt->fetch();
Actual result:
--------------
SQLSTATE[HY000]: General error: PDO_DBLIB: dbresults() returned FAIL
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=72488&edit=1
Thread (4 messages)