Plesk 6.5 for Windows - ASP/MySQL Connection String?

Anyone has ASP experience using Plesk 6.5 under Windows? I'm trying to connect to a MySQL database using ASP under Plesk 6.5.1, however, when I try to connect to my page I get the error:

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

The error appears to be the connection string, although I've tried several variations without success. What is the correct connection string for ASP/MySQL on Plesk 6.5? I've tried the following:

"driver={MySQL ODBC 3.51 Driver}; server=localhost; database=myDB; uid=daniel; pwd=xxx"
"driver={MySQL}; server=localhost; database=myDB; uid=daniel; pwd=xxx"
"driver={MySQL ODBC 3.51 Driver}; server=mydomain.com; database=myDB; uid=daniel; pwd=xxx"

Can anyone give me a correct connect string? My service provider was unable to. With Helm, the first connection string listed above worked like a charm.

 

 

 

 

Top