MSSQL: fail to query after transaction
| From: | Peter Vereshagin | Date: | Wed, 30 Apr 2003 07:04:10 +0000 |
| Subject: | MSSQL: fail to query after transaction | ||
| Groups: | php.db php.windows | ||
| Request: | Send a blank email to php-db+get-27438@lists.php.net to get a copy of this message | ||
Hello,
I am wondering that after I pass this to mssql:
===
begin transaction
insert ....
insert ....
commit
===
I can not query it again even after opening another mssql connection handle?
Even I cannot query mssql from another php if I use persistent connection?
The only message is "Query failed" but no problem dedscription at all neither the server
response.
The system is w2k-serv/IIS5/php-4.3.0 client and w2k-serv/mssql2000ee server.
The single insert/update queries go well, but transaction...