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... > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
