Error, IM002:1:0:[unixODBC][Driver Manager]Data source name not found, and no default driver specified

  • 7017884
  • 26-Jul-2016
  • 26-Jul-2016

Environment

NetIQ Privileged Account Manager
unixODBC Driver Manager
Microsoft ODBC Driver for SQL Server on Linux
FreeTDS Driver

Situation

Following steps to Enable Password Checkout for Microsoft SQL Server (MSSQL) database monitoring
Problem with unixODBC not recognizing, finding, picking-up the configured SQL driver
The following error displays after clicking "Test Connection" when configuring a new or modifying an existing Microsoft SQL Server Database Account Domain:
Error, IM002:1:0:[unixODBC][Driver Manager]Data source name not found, and no default driver specified

Resolution

Please verify the following:
  • The driver configuration file is named odbcinst.ini and is provided in the same path / directory / folder as odbc.ini
  • The ODBC Initialization Path is a path / directory and not an actual path to the file (i.e. /root/odbc.ini). Please provide a directory path to where both odbcinst.ini and odbc.ini files exist.
  • The Driver name defined in odbcinst.ini is the same as the Driver attribute defined in the datasource of odbc.ini.
    Note: If odbcinst.ini has the driver defined as “[ODBC Driver 13 for SQL Server]” then verify the odbc.ini references “Driver=ODBC Driver 13 for SQL Server”

Cause

This error is typically caused by a misconfiguration of the odbc.ini and odbcinst.ini files or the ODBC Initialization Path.