From: Operating system: Windows 7 PHP version: 5.3.10 Package: Unknown/Other Function Bug Type: Bug Bug description:SQLSRV problem to create new Transaction
Description: ------------ --- >From manual page: http://www.php.net/function.sqlsrv-begin-transaction.php --- I've used SQLSRV driever ver.2 with PHP. I must use SQL Transactions in my codes. But I get this error sometimes: "New transaction is not allowed because there are other threads running in the session" I updated SQL SERVER Native client too, but it could not solve anything. Test script: --------------- <?php // This is my psudo code if (sqlsrv_begin_transaction( $sqlsrv->sqlsrvLink ) === true) { $firstQuery = sqlsrv_query($stmt1); if (!$firstQuery) { sqlsrv_rollback(); } else { $nextQuery = sqlsrv_query($stmt2); if (!$nextQuery) { sqlsrv_rollback(); } else { sqlsrv_commit(); } } } ?> -- Edit bug report at https://bugs.php.net/bug.php?id=61199&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=61199&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=61199&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=61199&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=61199&r=fixed Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=61199&r=needdocs Fixed in release: https://bugs.php.net/fix.php?id=61199&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=61199&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=61199&r=needscript Try newer version: https://bugs.php.net/fix.php?id=61199&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=61199&r=support Expected behavior: https://bugs.php.net/fix.php?id=61199&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=61199&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=61199&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=61199&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=61199&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=61199&r=dst IIS Stability: https://bugs.php.net/fix.php?id=61199&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=61199&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=61199&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=61199&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=61199&r=mysqlcfg
