Same Problems as Jeremy AbsolutePage, RecordCount, EOF and BOF Errors

Hi there I am having the same problems as Jeremy.

I think I should first give some background.

I have a mirror of the site that I am currently working on running on a windows dev box. Though the live site runs chillisoft asp and MySql on linux.

The asp code that I am using runs on the dev box through Access and on the live through MySql.

I am now trying to make the dev box more closely reflect the live box by integrating activePerl for Perl proper (which I have done using an OS check so that no unix speciifc code executes in the dev environment.) and to use MySql instead of Access. So that when I ftp some code up to the live site no alterations have to be made to the numerous connection strings etc.

The errors only seem to occur when I am trying to page data. The
AbsolutePage as well as the RecordCount, EOF and BOF commands do not return the correct values.

If I use this connection string the code works
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\dev\sbol\database\booksdb.mdb; Persist Security Info=False"

If I then alter the connection string to this I get the above errors
objConn.Open "Driver={MySQL}; Server=localhost; Port=3306; Database=booksdb; Uid=books; Pwd=chips;"

Please can you guys help?

P.S. The username and password are correct etc and the MySql database holds the same data as the Access DB.

Hey,
I just answered that question in Jeremy's post: http://www.devarticles.com/forum/sh...hp?threadid=556 that should help you out