Bug #72488 [Fbk->NoF]: 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: php-bugs@lists.php.net Reported by: jamesking56 at me dot com Summary: PDO Dblib doesn't work with multiple rowsets -Status: Feedback +Status: No Feedback Type: Bug Package: PDO DBlib Operating System: Centos 7 PHP Version: 5.6.23 Private report: N New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. 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