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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How should dates be implemented so they work with other language and country formats?

953


How to load and unload child forms.

671


Draw Sequence Modal of RDO and Explain?

1871


Draw Sequence Modal of DAO and Explain?

1501


What do you mean by Databound Controls Explain?

1428






___ argument can be used to make a menuitem into bold.

1288


How to down load image properties.

606


Which language is used in visual basic?

487


Which type of object requires this object?

1581


Discuss the working with to-do lists.

577


How do I call help files from a VB program?

1004


How can you Implement windows functionality in VB?

1691


How many ways you can access file using VB?

573


What are the types of line styles available in Treeview Control?

1879


It is possible to access Text (x.txt) files? Explain.

1544