pending local transaction

  • Thread starter Thread starter Shawn
  • Start date Start date
S

Shawn

Is there anyway to determine if the OleDbConnection is in a pending local
transaction?

thanks,
Shawn
 
You can query the server for this information if the backend you are
connected to supports it.

For Sql Server it would be
sqlcommand1.CommandText = "select @@Trancount";
 
Thanks,
I'm using an Oracle DB.. Will this query return a count of all the pending
local transactions or just for the command object executing the query
(sqlcommand1) ?

Shawn

You can query the server for this information if the backend you are
connected to supports it.

For Sql Server it would be
sqlcommand1.CommandText = "select @@Trancount";
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transaction 4
DataAdapter with Transaction (.net 1.1) 3
Filling from inside a transaction? 3
Transaction for TableAdapters 1
Error: Pending Requests working on this transaction 2
Getting Errors with Transaction 3
transaction and command builder 4
still having problems with transactions 2

Back
Top