|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2016-09-12 22:24 UTC] adambaratz@php.net
[2016-09-14 21:48 UTC] adambaratz@php.net
-Status: Open
+Status: Feedback
[2016-09-25 04:22 UTC] php-bugs at lists dot php dot net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Oct 27 21:00:02 2025 UTC |
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