Link to home
Start Free TrialLog in
Avatar of Kani Str
Kani StrFlag for India

asked on

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

hi, I am getting
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
 error, while tring to connect MySQL from asp.
This is the code I am using
Set oConn = Server.CreateObject("ADODB.Connection")
stroConn = "Driver={mySQL};Server=localhost;Port=3306;Option=131072;Stmt=;Database=mydb;Uid=root;Pwd="
oConn.Open stroConn
Thanks in advance
- Kani
ASKER CERTIFIED SOLUTION
Avatar of hendridm
hendridm

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kani Str

ASKER

Thanks mate. It's ok now. Could you please tell me what was wrong there?

Thanks a lot
Avatar of hendridm
hendridm

Sure thing, the "Driver=" setting must match an actually name of a driver on your system.  To see a list of drivers, go to 'Administrative Tools' then 'Data Sources (ODBC)' then 'Drivers' tab.  The latest MyODBC driver from mysql.com installs itself as "MySQL ODBC 3.51 Driver".  Simple putting "Driver={mysql}" did not work because you apparently don't have a driver installed named 'mysql'.

Cheers,
Daniel
This is years later but this solved my problem. Fantastic!