vb 6 runtime error '-2147467259 (80004005)'

[notnotseven]

Hi,

I typed this in Visual Basic 6.0: ( for connecting Visual Basic 6.0 to oracle 8i )

Dim db as New ADODB.connection
Dim rs as New ADODB.recordset
_________________________________________________________________________________________________
Private Sub Form_Load()
db.Open "provider=MSDAORA.1;user id=scott;password=tiger;data source=registered;persist security info=false" ' end of first line
db.CursorLocation = adUseClient ' end of 2nd line
rs.Open "select * from registered", db, adOpenKeyset, adLockOptimistic ' last line
End Sub

(User id and password are correct. No doubt in that)

and unfortunately I received the error message for the first time, (The error was not displayed some 2 days ago)

Run-time error '-2147467259 (80004005)':
Oracle error occurred, but error message could not be retrieved from Oracle

(I re-installed the Oracle for one time. and no change! )


regards,
Dhilip,
B.E.,
C.S.E., 2nd year.

[notnotseven]

Hi
Please reply as soon as possible
Have to do project works on this

hope, I'll get a solution soon. thanks