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 permissions 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; 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.


  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

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...

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 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 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....