MySQL + ADO + ODBC

2002-12-22 Thread 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



Re: MySQL + ADO + ODBC

2002-12-22 Thread Venu
On Sun, 2002-12-22 at 17:25, Michael She wrote:
 Hi all,
 
 Does MySQL's ODBC v2.50 driver support Bookmarks?

MySQL doesn't support bookmarks, so no means that the drivers will
support this either :)


-- 
Regards, Venu
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  Palo Alto, CA-94306, USA
   ___/  www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


-
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