You need to invoke either the RollbackTrans or Comittrans methods before you can begin a transaction. Also, I would suggest using the OLE-DB Provider for SQL Server instead of the OLE-DB Provider for ODBC...

>I've faced to a problem that I don't know if it's real a problem:
>- I am using SQL 7.0 and ODBC, when I try to begin a transaction twice a receive the following error:
>"OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: Only one transaction can be active on this session..."
>Do you know what I have to do to solve this problem ?