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

Solution

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 Allow Remote Connection to MySQL Server in Windows?

This article will assist you to enable remote access to MySQL server through Windows command...

How to connect MySQL using PHP?

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

How to generate MySQL (backup) dump from the command line in Windows VPS?

This article will assist you how to generate MySQL (backup) dump from the Command line in the...

How to change phpMyAdmin password?

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

Fix - Collection Max error, Cannot Connect to Server

Problem Statement Recently one of our customers was unable to connect to Collection Max and...

  • 0 Users Found This Useful

Was this answer helpful?