Unspecified error during ADO Connection (the error show sometimes)

R

Riade

I am receiving an error during the connection to oracle db using ADO

Error Info *******************
Error No: -2147467259
Error Description: Unspecified Error
Error Source:provider


The error occured sometimes
I am developing in MS Access 2000

The code
dim con as ADODB.Connection
dim rs as ADODB.Recordset
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset

With con
.ConnectionString = "Provider=OraOLEDB.Oracle;Data
Source=ds;User ID=ui;Password=ps"
.ConnectionTimeout = 0
.CursorLocation = adUseClient
.Mode = adModeShareExclusive
.Open

End With



With rs

.ActiveConnection = con
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockOptimistic
.Source = "Select * from table1"
.Open , , , , adCmdText


End With



please help, I am really tired of this error

Remember the error occurs sometimes only
I have to close access, and reopen it to avoid the error


sincerely yours


Riade Asleh
 
Top