Having a weird issue with MS SQL Server. I'm trying to create a transaction and I've verified that I've started the transaction with
db.SQLExecute( "BEGIN TRANSACTION" )
but then when I got to commit I get the following error: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
I've verified that I'm not calling BEGIN TRANSACTION more than once but it *is* getting called with no errors.
Anyone have suggestions on things to look at?