
July 18th, 2010, 06:17 AM
|
Registered User
|
|
Join Date: Jul 2010
Posts: 3
Time spent in forums: 19 m 55 sec
Reputation Power: 0
|
|
ASP 1.0 - Connecting ASP to mySQL 5.5
Hi
I have asp pages. I have mysql 5.5 running at the back end.
I am try to connect MySQL5.5. But I am having a problem. I have download driver
mysql-connector-odbc-5.1.6-win32.msi and stalled it.
When I try to connect using connection string.
eg
ConnString= "DRIVER={MySQL ODBC 5.1.6 Driver}; SERVER=localhost; Database=testDB; UID=root; Password=mike; Option=4"
I am getting following error
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
But I have data source.
Please can some help, how I can pink point this problem.
Many thank
|