How to modify OLE DB's autocommit mode to manualcommit mode? 
Author Message
 How to modify OLE DB's autocommit mode to manualcommit mode?
I want to start nest transations(ADO->BeginTrans) in my program but not
allowed by OLE DB provider.   I wonder where to change its autocommit mode
to manualcommit mode?


Tue, 26 Apr 2005 15:47:59 GMT
 How to modify OLE DB's autocommit mode to manualcommit mode?

Jane,

Some provider do not support nested transactions through BeginTrans method
of ADO connection. What you could try to do is to execute BEGIN TRANSACTION
statement direcly, something like

MyConnection.Execute "BEGIN TRANSACTION"

MyConnection.Execute "BEGIN TRANSACTION"

......
MyConnection.Execute "COMMIT TRANSACTION"
MyConnection.Execute "COMMIT TRANSACTION"

--
Val Mazur
Microsoft MVP


Quote:
> I want to start nest transations(ADO->BeginTrans) in my program but not
> allowed by OLE DB provider.   I wonder where to change its autocommit mode
> to manualcommit mode?



Tue, 26 Apr 2005 21:04:52 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Default Table Lock-mode for DB-LIB, OLE DB Connections

2. Default Table Lock-mode for DB-LIB, OLE DB Connections

3. CRASH in debug mode (not in design mode) / access to DB

4. Detect Single-User mode in OLE/DB ?

5. Deadlock occuring when in AutoCommit(the default) mode

6. SQLOLEDB and autocommit transaction mode

7. AutoCommit mode in PostgreSQL (7.3 beta1 from CVS 05.09.2002)

8. A bad behavior under autocommit off mode

9. A bad behavior under autocommit off mode

10. autocommit off mode, how does it work?

11. A bad behavior under autocommit off mode

12. SQLOLEDB and autocommit transaction mode


 
Powered by phpBB® Forum Software