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

Binary Access-method isused to access file in which manner?

1663


What is Seek Method which type of record set is available this?

1687


Explain about an event-driven programming language?

729


What are the uses of List View Control?

1743


What is vbs file?

767


Explain the usage of Web Browser Control?

1707


What is the use of Scalewidth and ScaleHeight Proeperty?

1701


Is it possible to set a shortcut key for label?

1593


What are 3 main differences between flexgrid control and dbgrid control?

2144


Can you create a Updatecascade, Deletecascade relation in Ms- Access?

1893


How do I make the mouse cursor invisible/visible?

1117


What is DDE?

1984


How can you Add API functions to your Application?

1542


I have several megabytes of memory. Why do I get an "out of memory" error?

1311


How do I do Peek and Poke and other low-level stuff?

1190