KB47255: "Connect failed...Data source name not found and no default driver specified" error appears when connecting to MySQL Community 5.1 from MicroStrategy DB Query Tool running on Red Hat Enterprise Linux 6.1

• Strategy

This document explains a possible cause for error when connecting to MySQL database from Linux operating system

SYMPTOM
The following error message appears when connecting to MySQL Community 5.1 from Strategy DB Query Tool running on Red Hat Enterprise Linux Operating Systems:


Connect failed.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. Data source name not found and no default driver specified.

CAUSE
The possible causes are either a missing ODBC Library or an invalid ODBC Library path.

ACTION

Missing ODBC Library: Install the MySQL ODBC 5.2.5 odbc driver (or other recommended versions by the vendor) to connect to the MySQL Community 5.1 data source.
Invalid ODBC Library path: Set the ODBC library path correctly in the odbc.ini file (found in the home folder of the Strategy installation). Find below an excerpt from the odbc.ini file from a Strategy 9.4.1 installation:


MySQL=MySQL ODBC 5.1 Driver
Driver=/usr/lib/libmyodbc5w.so
Description=MySQL ODBC 5.2 Driver
SERVER=
PORT=3307
USER=
Password=
DATABASE=
OPTION=3
SOCKET=
DriverUnicodeType=1

Third Party Software Installation Warning:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.

Comment

0 comments

Details

Knowledge Article

Published:

May 8, 2017

Last Updated:

May 8, 2017