ASP and MySQL

[Stephen Duff]

<%

dim adoConn

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

adoConn.Open "DSN=MySQL_dsn"

if adoConn.errors.count = 0 then

response.write "Connected Successfully!"

end if

%>

Get an error on line adoConn.Open

Error Message:

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10022)

Please help its doing my head in :-)