asp.net - "Data source name not found and no default driver specified" connecting mysql -

asp.net - "Data source name not found and no default driver specified" connecting mysql -

due technical reasons, had alter database sql server mysql. getting next error, cannot connect database..!

microsoft ole db provider odbc drivers error '80004005'

[microsoft][odbc driver manager] info source name not found , no default driver specified

set objconn = createobject("adodb.connection") objconn.open ("driver={mysql odbc 5.0.96 driver};server=68.128.172.38;database=xxx;uid=xxx;pwd=xxx")

here go sample connection string

server_name = "localhost" 'connect local remort database server databsename = "db" 'database name mysqluser = "root" 'user name mysqlpassword = "admin" 'passwrd of db user constr= "driver={mysql odbc 5.1 driver};server=" & server_name & ";database=" & databsename & ";uid=" & mysqluser & ";pwd=" & mysqlpassword & ";port=3306;option=67108864;" ' connection string

if doesn't work, seek installing relevent connector mysql select , download connector

mysql asp.net asp-classic oledb