Database Connection to mysql from asp

[Steve Jacobs]

Good day everybody. I am a new comer to this site and instead of reading all the topics I think it is wise for me to go straight and ask my question.
I formerly use MS Access database connection before and I can connect to my Access database via the following code:
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/my_database.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Customers", conn
%>
As a new user of MySql, I am eager to connect to my mysql database. I've created the database and have created a table in the database with some columns. I can use mysql to display the table but I want to connect to the table from asp which is the server side scripting I specialize. How can I get it done? How can I locate the MySQL database I created and what is the extension?
If I want to create an ODBC connection to the database how can I locate the driver cos its not in the list?
Thanks in anticipation everybody. I want to migrate from Access to MySQL