Microsoft OLE DB Provider for ODBC Drivers error '80004005'

by Ramya 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.Embarassed
* You have not selected the driver in DSN.Rolling eyes
* Connection string may not properly set.Question

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:

Tagged in:

1436
like
0
dislike
0
mail
flag

You must LOGIN to add comments