Guest_imported
New member
- Jan 1, 1970
- 0
When using ADO to connect to an Oracle 8i database I get the following error
Private Sub Form_Load()
Dim cn As ADODB.Connection
Dim conn As String
conn = "uid=dave;PWD=dave;DRIVER={Microsoft ODBC For Oracle};SERVER=ora1;"
Set cn = New ADODB.Connection
With cn
.ConnectionTimeout = 30
.CommandTimeout = 30
'.Provider = "MSDASQL"
.ConnectionString = conn
.Open
.DefaultDatabase = "maximo"
End With
Text1.Text = "Connection established with " + cn.DefaultDatabase
End Sub
Can anyone help?
Thanks,
Dave
Private Sub Form_Load()
Dim cn As ADODB.Connection
Dim conn As String
conn = "uid=dave;PWD=dave;DRIVER={Microsoft ODBC For Oracle};SERVER=ora1;"
Set cn = New ADODB.Connection
With cn
.ConnectionTimeout = 30
.CommandTimeout = 30
'.Provider = "MSDASQL"
.ConnectionString = conn
.Open
.DefaultDatabase = "maximo"
End With
Text1.Text = "Connection established with " + cn.DefaultDatabase
End Sub
Can anyone help?
Thanks,
Dave