Re: transactions using freetds and php

> -----Original Message-----
> From: [email protected] [mailto:freetds-
> [email protected]] On Behalf Of Ben Vogan
> Sent: 24. kesäkuuta 2010 19:58
> To: [email protected]
> Subject: [freetds] transactions using freetds and php
> 
> 
> Hi all,
> This might be more of a PHP question that freetds but I thought I would
> try my luck here.  I was wondering what the proper way to use
> transactions from PHP talking to SQL Server 2008.  I tried:
> mssql_query('BEGIN TRANSACTION');try {  loop {  //multiple inserts here
> }  mssql_query('COMMIT TRANSACTION');} catch (Exception $ex) {
> mssql_query('ROLLBACK TRANSACTION');}
> However I get errors that there was no begin transaction.  Is this
> pattern possible in PHP or do I have to concatenate all my sql into one
> query (which would be very unfortunate)?
> Thanks for your help,--Ben

You might want to try give your transaction a name:

mssql_query("{BEGIN|COMMIT|ROLLBACK} TRANSACTION MyTransAction");

And make sure that transaction begins and ends with the very same connection.


Niklas