VB6.0 Connectivity to Oracle
How to connect oracle 9i to vb6.0 using active X data objects? please mention the code..
Thnx ...
Saurabh
Software/Hardware used:
Thnx ...
Saurabh
Software/Hardware used:
ASKED:
December 2, 2009 5:18 AM
UPDATED:
May 20, 2011 10:40 AM
Answer Wiki:
Here's an ADO example:
<pre>Dim adoCn As New ADODB.Connection
Dim sConString As String
sConString = "Provider=MSDAORA.1;Password=<your password>;" _
& " User ID=<your user name>;Data Source=<your oracle database alias>;" _
& " Persist Security Info=True"
With adoCn
.ConnectionString = sConString
.CursorLocation = adUseClient
.ConnectionTimeout = 30
.Open
End With
'...
'... do your database operations
'...
adoCn.Close</pre>
Note that you need to add a reference to the ActiveX Data Objects library to your porject, and you have to have the oracle client software installed.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
