Hi there,
Before using MySQL with ASP, you need to install the MySQL ODBC driver on the machine that the ASP application is running, and ensure that port 3306 is open on the machine running MySQL.
The ODBC driver for MySQL can be found
here (both x86 and x64 versions).
Then, read the documentation and there are examples of how to create a DSN, or DSN-less, connection string using the MySQL ODBC connector. Simply use this code in your ASP app and that's it!
Hope this helps.
Best regards,
medicineworker