I was trying to use the Recordcount in asp with MySQL and always came up with -1.  It took me sometime finding a solution. Apparently MySQL does not support Server Side Cursors. Here is a quick fix:

To make this work you will need to set the CursorLocation to 3:

Set objRS = Server.CreateObject(”ADODB.Recordset”)
objRS.CursorLocation = 3
objRS.Open mySQL, objConn

Hope this helps!

This entry was posted on Tuesday, November 13th, 2007 at 9:25 am and is filed under programming. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.