Hi ALeksey

>Just to make it clear, SQLSETPROP(connectionhandle,"Transactions",2) is equivalent to BEGIN TRANSACTION.

Is that really correct? After issuing
SQLSETPROP( connection, "Transactions", 2 )

The query: SQLEXEC( connection, 'SELECT @@TRANCOUNT' )
returns 0 and certainly there is no behavior to suggest that a transaction has been started.

However, if I use: SQLEXEC( connection, 'INSERT INTO....' )
Then check the transaction count, I see '1', as expected.

I thought that all that setting the transactions property of the connection
to "manual" does is to require that the client must explicitly close implicit transactions with SQLCOMMIT/SQLROLLBACK?