Is it possible to call oracle database through ADO control
or Object?



Is it possible to call oracle database through ADO control or Object?..

Answer / subashini

yes,its possible.

First select the Microsoft ActiveX Data Objects 2.0 library
in References


Dim conn as New ADODB.Connection
Dim rs as New ADODB.Recorset

Private sub Form_Load()
conn.Open "Provider=MSDAORA.1;userid=scott;password=tiger;
persist security info=true"
conn.CursorLocation=adUseClient
End sub

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Visual Basic Interview Questions

How many objects resides in ADO ?

0 Answers  


What are the rules which should be followed while naming a variable in VB?

0 Answers  


What are forms in visual basic?

0 Answers  


What is a thread pool and how are the threads within a thread pool managed?

0 Answers  


What is vbs file?

0 Answers  






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

0 Answers  


how many no of controls in form?

1 Answers   Airex Logistics, Tata Logistics,


What is the latest version of visual basic?

0 Answers  


What is the difference between adodc and adodb in vb?

0 Answers  


How do I create controls dynamically (at run-time)?

0 Answers  


Explain the "cursortype" and "Locktype" in VB?

1 Answers  


How can you determine performance standards?

0 Answers  


Categories