Article ID: 127945, created on Dec 29, 2015, last review on Dec 29, 2015

  • Applies to:
  • Plesk Automation 11.5

Symptoms

The website application cannot connect to database with the connection string:

Driver={MySQL ODBC 3.51 Driver};Server=203.0.113.2;Port=3306;Database=testdb;User=user;Password=123qwe;Option=3

The following error is thrown:

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

Cause

The driver specified in the connection string is not installed on the system the connection is originating from.

Resolution

  1. Download the driver from official site and install it on the server that runs the affected website.

Search Words

Data source name not found and no default driver specified

MySQL ODBC

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

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

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF