RE: [PHP-WIN] MSSQL: fail to query after transaction
| From: | HKG) | Date: | Thu, 01 May 2003 10:11:46 +0000 |
| Subject: | RE: [PHP-WIN] MSSQL: fail to query after transaction | ||
| References: | 1 | Groups: | php.db php.windows |
| Request: | Send a blank email to php-windows+get-19737@lists.php.net to get a copy of this message | ||
Hard to tell from the description, but may it be the case that
a second try (with same data) violate primary key constraints?
> -----Original Message-----
> From: Peter Vereshagin [mailto:petr999@mail.ru]
> Sent: Wednesday, April 30, 2003 9:04 AM
> To: php-windows@lists.php.net; php-db@lists.php.net
> Subject: [PHP-WIN] MSSQL: fail to query after transaction
>
>
> 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...
>