Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 3251 when connecting to Oracle 8i database

Status
Not open for further replies.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top