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

Clear property is available in hich control?

2 Answers  


Define the scope of Public, Private, Friend procedures?

1 Answers  


What is the default model of the form?

0 Answers   Transtech,


what is the Difference between listbox and combo box?

5 Answers   TCS,


How the image application?

0 Answers  


Which property of textbox cannot be changed at runtime?

1 Answers  


How do you change the system menu (on the Control-Menu Box)?

0 Answers  


How would you create properties by using class Builder Wizard?

0 Answers  


what is different between edit and update?

5 Answers   Wipro,


What is RDO?

1 Answers  


What is the difference between Msgbox Statement and MsgboxQ function?

1 Answers  


How many types of API functions are available in VB?

0 Answers  


Categories