Transactions and Workspaces 
Author Message
 Transactions and Workspaces

I'm having a problem using the BeginTrans method on an ODBC datasource.

I start the transaction using gdbDatabase.BeginTrans and obviously end the
transaction with gdbDatabase.CommitTrans or gdbDatabase.Rollback.

It works fine but before the Commit or rollback, I need to read from another
database (Access).  I get an error when trying to read from this database while
in a transaction, and subsequently cannot get to the commit or rollback because
of the error.  I suspect that VB4's workspaces will solve this problem but I am
having a hard time understanding how to implement them.

Should I be creating a workspace for the transaction methods (ODBC datasource)
and a separate one for reading the Access tables?

Need help on this one fast.  Anybody?



Sun, 30 Aug 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Q: DBEngine - vs- Workspace & transactions

2. Transaction Problem: VBA Workspace Object

3. recordsets getting reset inside a workspace transaction...

4. Form is by-passing workspace transaction batch

5. Workspaces, recordset & transactions: help needed

6. WorkSpaces and Transactions

7. Workspace Transaction Begin/Commit/Rollback bug?

8. Transactions/Workspaces/Recordlocks

9. To Transaction or Not to Transaction that is the question

10. ADODB TRANSACTION ADO ERROR No Transaction is Active

11. Why to use COM+ transaction and not just SQL Server transaction

12. Reqiured Transaction and Required New Transaction

 

 
Powered by phpBB® Forum Software