Which ADO object is used to perform commit / rollback ?
Is it command or connection or recordset

I am not sure of the options given. So please let me know
the answer if it is something else.

Answers were Sorted based on User's Feedback



Which ADO object is used to perform commit / rollback ? Is it command or connection or recordset ..

Answer / ghanshyam vrema

ye, through Connection object you can commit or rollback
the transaction Eg:

on error go to errhandler
con.BeginTrans

con.execute cmd
con.execute cmd2
con.CommitTrans
errhandler:
con.RollbackTrans

Is This Answer Correct ?    18 Yes 0 No

Which ADO object is used to perform commit / rollback ? Is it command or connection or recordset ..

Answer / senthil

Connection object

Is This Answer Correct ?    14 Yes 0 No

Which ADO object is used to perform commit / rollback ? Is it command or connection or recordset ..

Answer / anjani

Connection Object of ADO is Used to Perform Commit and
Rollback.

Is This Answer Correct ?    9 Yes 0 No

Which ADO object is used to perform commit / rollback ? Is it command or connection or recordset ..

Answer / john ranjith

Connection object will be used to commit / rollback the
transaction

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Visual Basic Interview Questions

___ is the control used to call a windows application.

0 Answers  


How do I prevent multiple instances of my program?

0 Answers  


How would you navigate between one document to another document

0 Answers  


Draw Sequence Modal of RDO? Explain.

0 Answers  


Difference Types of Instancing Property in ActiveX Dll and Exe.

1 Answers  


what are Collections?

1 Answers  


Does VB Supports OOPS Concepts? Explain..

4 Answers  


How do I force a file dialogue box to reread the currect disk?

0 Answers  


CONNECTIVITY OF SQL 2000 + VB USING ODBC. steps i Follow- 1) Go to Control panel-->Admintrative Tools-->Double -click Data sources(ODBC)-->click Add button-->I choose SQL server (last option), Is it right or wrong option for connecting to SQL 2000.Then a new screen appears Create a New dataSource-->in name textbox,we can write anyname--Right or wrong. suppose i enter sonia, & my server name is .,so I enter . in server & click next button-->On the Next screen i have checked the option With Sql server authentication-- >Login Id-sa, Password-->Blank-->Click next button-->Next-- >Finish-->Then I click on button Test Data source-->Mesage Comes TESTS COMPLETED SUCCESSFULLY-->OK-->OK-->Ok. These steps we have to do or not for Connectivity using ODBC. If yes,then what after these steps we have to do??Plz reply me early ??Thx in advance.

6 Answers  


HTML stands for What? Use of HTML ?

1 Answers  


Explain the usage of Web Browser Control?

0 Answers  


What are the objects in ADODB?

1 Answers  


Categories