Asp and MySql connection

I am a web developer, using Asp and MySql for a project.
I have tried to setup a DSN but couldn't find the provider for mysql connection, hence could not able to setup it.
Also I have tried
<%
strConnection = "driver={MySQL};server=localhost;uid=;"
strConnection = strConnection & "PASSWORD=;database=databaseName"
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open strConnection
%>

but it is giving me error as
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

would anybody help me please? I am getting late for this project.
Is there any way from which I can download the provider for Mysql connection via Asp? or another solution you would like to suggest? please I would be thankfull to .....

You need to download the driver from the mysql site first.

Hi, maybe I'm too late for this reply,but anyway this is what I normally do....

1. set up a system dsn name using the Data Sources (ODBC), for example: MySQLCon

2. connect to the database in asp like this:

<%
Dim Con, RS, SQL
Set Con= Server.CreateObject("ADODB.Connection")
Con.Open "DSN=MySQLCon"
SQL = "SELECT .........."
%>

You shoukd download Snitz Forums (http://forum.snitz.com) to research