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 can you get selected file from file system Control?

0 Answers  


What is the difference between change event in normal combobox and dbcombobox?

0 Answers  


How can you Implement windows functionality in VB?

0 Answers  


Difference between Linked Object and Embedded Object?

0 Answers  


which arguments will be used to run a executable program in shell function ?

1 Answers  






Draw Sequence Modal of DAO? Explain.

0 Answers  


Difference Types of Instancing Property in ActiveX Dll and Exe.

1 Answers  


How would you access objects created in ActiveX Exe and ActiveX Dll

0 Answers  


What is the use of command Object?What are the various types of variables?

0 Answers  


What are the Internet tools available in VB 6.0?

0 Answers  


Through which protocol OLEDB components are interfaced?

0 Answers  


Explain about ADO control?

0 Answers  


Categories