Problems connecting to mySQL

Can anyone help me?

I have 2 servers. One is unix running php and mysql. The other is windows and asp.

I want to have an asp script that queries the mysql server.

Using the tutorial from this site, I am trying to use a connection string to connect to the mysql server. Here is my code:

<%
dim adoConn

set adoConn = Server.CreateObject("ADODB.Connection")

adoConn.Open "Driver={mySQL}; Server=xxx.xxx.xxx.xxx; Port=3306; Option=0; Socket=; Stmt=; Database=xxxxxx; Uid=xxxxxx; Pwd=xxxxx;"

if adoConn.errors.count = 0 then

response.write "Connected Successfully!"

end if
%>

This fails with the error:

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

Why am I getting an error about ODBC Drivers and Data Source names when I am trying to use a connection string?

Please help?!

Thanks,
B

Did you download and install MyOLEDB http://www.mysql.com/downloads

Afterwards you can use:
oConn.Open "Provider=MySQLProv.2.5; Server=xxx; Database=xxxx;uid=;pwd=;port=3306"

try being more specific with driver:

adoConn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=xxx.xxx.xxx.xxx; Port=3306; Option=0; Socket=; Stmt=; Database=xxxxxx; Uid=xxxxxx; Pwd=xxxxx;"