2. ASPRunnerPro General questions
  3. HELP!!!!!!! Can't connect to MySQL Dat
This topic is locked

HELP!!!!!!! Can't connect to MySQL Dat

 		10/7/2004 11:50:13 PM
ASPRunnerPro General questions
C
 ctgause author

I haven't seen any post about connecting to a MySQL Database from web. I can connect to database from localhost but when I publish to the web. I get the following error.
-2147467259
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I know the code is correct so what is wrong?
Sergey Kornilov admin 10/11/2004

Hi,
please post your connection string that can be found in include/..._dbconnection.asp.
C
 		ctgause author 10/16/2004

Never mind, the host that has my asp files doesn't allow dsn connections. Switched to hosting my own web server.
501091 10/16/2004

Could you not use a DSNless string like server.mappath. ASPRunner gives you this option when building your pages.
The string would be something like:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/northwind.mdb")
Regards

Martin
501092 10/19/2004

I'm connecting to a mySQL database