Kani Str
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 .Connectio n")
stroConn = "Driver={mySQL};Server=loc alhost;Por t=3306;Opt ion=131072 ;Stmt=;Dat abase=mydb ;Uid=root; Pwd="
oConn.Open stroConn
Thanks in advance
- Kani
[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
stroConn = "Driver={mySQL};Server=loc
oConn.Open stroConn
Thanks in advance
- Kani
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Cheers,
Daniel
This is years later but this solved my problem. Fantastic!
ASKER
Thanks a lot