No announcement yet.

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


Unconfigured Ad Widget

  • Filter
  • Time
  • Show
Clear All
new posts

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

    Problem Statement

    unable to connect mysql db through my ASP.NET application.

    Error Message

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


    In order to fix this issue, we have added connector for ODBC 5.x DSN on Windows. Following are the steps:
    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.

    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.
    Last edited by Marc_AccuWebHosting; 06-08-2015, 10:53 PM.