KB426546: Error "Data source name not found and no default driver specified" appears when MicroStrategy connects to Mysql on Linux

Quality Engineer, Senior • MicroStrategy

Error "Data source name not found and no default driver specified" occurred while attempting to connect to a MySQL Database in Linux.

Symptom

Error message "Data source name not found and no default driver specified" appears when Intelligence Server attempts to connect to a MySQL Database on Linux.


[Database Classes][Error] Failed to connect to data source. Error message: Connect failed.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [IM002:0: on SQLHANDLE] [DataDirect][ODBC lib] Data source name not found and no default driver specified Connection String: DSN=Select a DSN;UID=root;.

Cause

The character encoding of the Database Connection is set to UTF-8.

Action

1. Go to Database Instance Editor, modify the Database connection.
2. Change character set encoding for Unix drivers to Non UTF-8 in Advanced tab.
3. Restart Intelligence Server to make the change work.

Comment

0 comments

Details

Knowledge Article

Published:

January 18, 2018

Last Updated:

March 4, 2024