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 MDI(multiple document interface) forms can include in one project(especially in visual basic)?

6 Answers   Satyam, VSS,


What is the difference between modal and modaless form in VB?

1 Answers  


Why does everybody say I should save in TEXT not BINARY?

0 Answers  


Is it possible to change menu runtime using API? If yes Specify the function names?

0 Answers  


What is the difference between queryunload and unload in form?

2 Answers  






I belive VB6 is a powerful and matured tool that any other front end tool, why is it outdated? is it because of lack of awareness or because of difficult to use?

5 Answers   HCL,


When Activex exe is benificial in vb application

1 Answers   TCS,


What is hyperlink?

1 Answers  


What is the use of Tabledef?

0 Answers  


How do I implement an incremental search in list/dir/combo/file boxes?

0 Answers  


With in the form we want to check all the text box control are typed or not? How?

0 Answers  


Which type of object requires this object?

0 Answers  


Categories