IBM Support

Testing ODBC data source connection results in error: Unable to load the driver manager library

Troubleshooting


Problem

When attempting to test an ODBC data source connection using IBM Rational Insight, a login error is received: " ...The logon failed for the following reason: RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database..."

Symptom

The full error message is:

QE-DEF-0285 The logon failed.
QE-DEF-0324 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
   testDataSourceConnection

UDA-SQL-0569 Unable to load the driver manager library (libodbc.so).
UDA-SQL-0571 The operating system returned an error message ( libodbc.so: wrong ELF class: ELFCLASS64 ).

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(744): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction BmtActionsHelper.cpp(475): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(603): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest();
QFSSession.cpp(601): QFException: CCL_CAUGHT: QFSSession:ProcessDoRequest();
QFSSession.cpp(1417): QFException: CCL_RETHROW:QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2064): QFException: CCL_RETHROW_QE
Source/QEI_ConnectionFault.cpp(807): QFException: CCL_THROW: QE




Cause

The IBM Cognos Business Intelligence server does not support 64-bit 3rd party libraries

Resolving The Problem

If you are using a 64-bit Linux operating system, you must install the 32-bit ODBC driver manager of your preference. Please refer to IBM Cognos techdoc 7017522 for more information regarding support for third party libraries.

Refer to the section titled Configuring the ODBC driver in the Rational Insight Information Center for more information on supported ODBC Driver Managers.

[{"Product":{"code":"SSRL5J","label":"Rational Insight"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Cognos Business Intelligence Server","Platform":[{"code":"PF016","label":"Linux"}],"Version":"1.0;1.0.0.1;1.0.0.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21426591