multiple recordsets with ASP and MySQL

One big issue I've run into when working with MySQL is having
multiple recordsets in the same ASP script. It appears that this is not
allowed. This is crazy though because you will often need multiple recordsets within the same script. The error I get from the server is "datasource name not found and no default driver specified." I know this means it can't find the
connection information, but I know this is incorrect because as soon as I
remove the second recordset from the script, the page displays correctly.

I'm using a variable called connect which stores the connection object.
My scripts operate fine using this variable with just one recordset. For
the second recordset, I even tried setting up a second connection object with a new variable name but still no luck.

Has anybody else encountered this problem using ASP and MySQL and if so, were you able to solve it?

Well, I don't know what was happening before that prompted me to write this post, but it's no longer an issue. I use multiple recordsets all the time with no trouble. It's nice when problems with your code just sort of "work out!"