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"
.ConnectionString = sConString
.CursorLocation = adUseClient
.ConnectionTimeout = 30
'... do your database operations
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.
Last Wiki Answer Submitted: December 2, 2009 5:53 pm by carlosdl63,535 pts.