connecting ASP with MySQL

[meenakshidhar]

hi all,
i m getting this error while connecting ASp with Mysql
---------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

---------------

my connection string is
<%
Set pConn = Server.CreateObject("ADODB.Connection")
pConn.open "driver={MySQL};uid=username;pwd=pass;database=db_name;server=ipaddress"
%>

 

[ChrisHirst]

you are probably using the wrong driver version. Yours is set for Ver 2.5

driver={MySQL ODBC 3.51 Driver}



Chris.

Indifference will be the downfall of mankind, but who cares?