Fix :: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found

Error Message

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


One of our Windows VPS customers was unable to connect to mysql db with ASP.NET application. In order to fix this issue, we have added connector for ODBC 5.x DSN on Windows VPS as follows.

  1. On the Start menu, choose Administrative Tools, and then click Data Sources (ODBC). Open the ODBC Data Source Administrator.

  2. To create a System DSN (which will be available to all users), select the System DSN tab. To create a User DSN, which will be unique only to the current user, click the Add button.

  3. Select the ODBC driver for this DSN.

  4. Select MySQL ODBC 5.x Driver for the appropriate level of Connector/ODBC, then click Finish.

  5. You now need to configure the specific fields for the DSN you are creating through the Connection Parameters dialog.

    Mysql ODBC Windows Driver Select MySQL ODBC Window Datasource Config

  1. In the Data Source Name box, enter the name of the data source to access. It can be any valid name that you choose.

  2. In the Description box, enter some text to help identify the connection.

  3. In the Server field, enter the name of the MySQL server host to access. By default, it is localhost.

  4. In the User field, enter the user name to use for this connection.

  5. In the Password field, enter the corresponding password for this connection.

  6. The Database pop-up should automatically populate with the list of databases that the user has permission to access.

  7. To communicate over a different TCP/IP port than the default (3306), change the value of the Port.

  8. Click OK to save the DSN.

To verify the connection using the parameters you have entered, click the Test button. If the connection could be made successfully, you will be notified with a Success; the connection was made! dialog.

Do you know what kind of database connectivity we do offer? Please take a look at this URL to know more.

Related Articles

How to change phpMyAdmin password?

Following tutorial will guide you to reset the phpMyAdmin password. We assume that you have...

How do I connect to MySQL server from phpMyAdmin?

This article will guide you on how to connect to MySQL server from phpMyAdmin. You can obtain...

How to connect MySQL using PHP?

You can connect your MySQL with PHP using the below methods. Method 1 - PHP extension(mysqli)...

How to Enable Relation View in phpMyAdmin?

The option Relation View is probably one of the best features available in phpMyadmin. Sometimes...

How to Stop and Start MySQL Service in Windows and Linux VPS?

This article will assist you to stop and start MySQL service from Windows VPS and Linux VPS....

  • 0 Users Found This Useful

Was this answer helpful?