Bug #72488 [Opn->Fbk]: 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 +Status: Feedback Type: Bug Package: PDO DBlib Operating System: Centos 7 PHP Version: 5.6.23 Block user comment: N Private report: N Previous Comments: ------------------------------------------------------------------------ [2016-09-12 22:24:27] adambaratz@php.net 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;' ------------------------------------------------------------------------ [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