Re: rs.absolutepage stopped working with MySql ;-(

I am not an expert on this but I had a similar problem which I solved by
moving the db "off shore" , i.e. to an external web hosting provider and
changing the connection string to:

set Conn = server.CreateObject("ADODB.connection")
Conn.open "Provider=MySQLProv;Location=mysql.mydomain.com;Data
Source=mydb;User ID=user;Password=pw

(check the string content with your web hosting provider)

If your database is local (on your PC) you're stuck with:

set Conn = server.CreateObject("ADODB.connection")
Conn.open "DRIVER={MySQL ODBC 3.51
Driver};SERVER=mysql.mydomain.com;DATABASE=mydb;USER=user;PA SSWORD=pw;OPTION=3"

and that one does not support paging AFAK.

TB

"David" wrote in message
news:1118480609.761121.285260@z14g2000cwz.googlegroups.com.. .
> Hi All
> I have just migrated from MS Access to MySql but I have a problem with
> using a recordset. The code worked for MS Access and I have not
> altered the code in anyway but am now getting the following error:
> ADODB.Recordset (0x800A0CB3)
> Current Recordset does not support bookmarks. This may be a limitation
> of the provider or of the selected cursortype.
>
> I use the following to open the recordset:
> set con = server.createobject( "ADODB.connection" )
> con.open application("dbcon")
>
> set rs = CreateObject("ADODB.Recordset")
> rs.activeconnection = con
> rs.cursortype = adopenstatic
> rs.pagesize = perPage
>
> rs.open sqlString
>
> but the problem comes with the following statement:
> rs.absolutepage = pageNum
>
> I am a MySql newbie so it may be a silly mistake but any help would be
> greatly appreciated.
>
> Thanks in advance
>