MySQL + ADO + ODBC

[Michael She]

Hi all,

Does MySQL's ODBC v2.50 driver support Bookmarks?

I can only get ADO bookmarks to work with a Client Side Cursor.

Here is some sample code:

strSQL = "SELECT * FROM IMAGES WHERE `CATID` = " & CatID
rs.CursorLocation = 3 'Client Side Cursor
rs.open strSQL, objConn

rs.PageSize = 1
rs.absolutepage = LocationCount <-- This line dies with the error message:

Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.

If I do not use a Client side cursor.
--
Michael She : [EMAIL PROTECTED]
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php