KB44527: "Data source name not found and no default driver specified" error appears when connecting to a DSN using DB Query Tool in MicroStrategy 9.x on Linux

• Strategy

This article discusses a symptom of "Data source name not found and no default driver specified" when trying to connect to a machines DSN. This is seen when the DSN name itself has spaces in it.

SYMPTOM:
"Data source name not found and no default driver specified" error appears when connecting to a DSN using DB Query Tool in Strategy 9.x on Linux, as shown below:


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

CAUSE:
One possibility of the issue is that one or more spaces are in the Data Source Name (DSN), as shown below:

ACTION:
Configure the DSN, and remove the space(s) in the name.

NOTE: Go and run following executive file to access the 32-bit ODBC drivers on a 64-bit Windows machine:


\SysWOW64\odbcad32.exe

Comment

0 comments

Details

Knowledge Article

Published:

April 3, 2017

Last Updated:

April 3, 2017