Troubleshooting > Troubleshooting DataConnect > Data source name not found and no default driver specified
Was this helpful?
Data source name not found and no default driver specified
 
Error Code
19
Error Message
Error 19 connecting to 'MySQL (ODBC 3.5)': From Connect (driver): SQL state IM002, message:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Description
This error is displayed for connectors like MySQL when the ODBC driver is not installed or the Data Source Name for the driver is not configured.
Cause/Solution
 
Cause: The ODBC driver is not installed or the Data Source Name for the driver is not configured.
Solution: For the first problem, the required ODBC driver must be identified and installed. In most cases, the vendor of your database will provide the driver and instructions on how to configure it. If the problem still persists, configure the Data Source Name for the driver. The location for Windows ODBC configuration is below, but the driver vendor should have full instructions on how to configure the DSN.
Related Information
Last modified date: 10/22/2024