DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC 9.02.00.03 Invalid Bookmark

372667Nov 19 2002

Hallo,

I've problems with oracle odbc. Currently I'm using version 8.01.62.00 (SQORA32.Dll). With this the following code works fine.

Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
conn.Open "oraodbc", "scott", "tiger"
rs.Open "select * from emp", conn, adOpenStatic, adLockReadOnly, adCmdText
rs.MoveFirst
While (Not rs.EOF)
rs.MoveNext
Wend
Debug.Print "recordcout= " & rs.RecordCount
rs.MoveFirst
While (Not rs.EOF)
rs.MoveNext 'invalid bookmark value
Wend
rs.Close
conn.Close

If I using the ODBC shiped with Oralce 9i (tested till version 9.02.00.03 SQORA32.DLL) a error 'invalid bookmark value' occurs. Whats wrong with the Oralce 9 ODBC drivers? All other drivers (ADO) are the same.
Tested with MS ActiveXData Objects 2.0 - 2.6 Library. I'm using MS Visual Studio Version 6 with SP4.

Thanks
Ralf

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2002

Added on Nov 19 2002

#odbc, #windows-and-net

0 comments

242 views