Microsoft OLE DB Provider for ODBC Drivers error '80004005'
by Ramya[ Edit ] 2009-08-31 19:43:36
Microsoft OLE DB Provider for ODBC Drivers error '80004005':
In some cases while connecting with database, we may face the issue like,
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /test.asp, line 14
This error may occur due to one of the following,
* Mysql database ODBC Driver may not installed.
* You have not selected the driver in DSN.
* Connection string may not properly set.
Mysql database ODBC Driver Installation:
Check whether the Mysql ODBC 3.51 Driver is installed orelse install the driver "Mysql database ODBC Driver".
Mysql ODBC 3.51 Driver
Select the driver in DSN for which you want to set up a data source:
Add the driver under "System DSN" in "Data Source ODBC" found in Control Panel-> Administrative tools.
Creating new system DSN
Connection String for Mysql in ASP:
Get the connection string code:
