Troubleshooting
Problem
When running cqreg command, an error will occur if the SQL Server driver is not correctly configured for use with IBM Rational ClearQuest 9.1.x and higher on Linux.
Symptom
11:39:57 AM ... The vendor error message was:
11:39:57 AM ...
11:39:57 AM ... CRMDB0000E SQLDriverConnect: RETCODE=-1, State=01000, Native Error=0
11:39:57 AM ... [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.4.so.2.1' : file not found
11:39:57 AM ::: [cqreg has finished with errors]
11:39:57 AM ...
11:39:57 AM ... CRMDB0000E SQLDriverConnect: RETCODE=-1, State=01000, Native Error=0
11:39:57 AM ... [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.4.so.2.1' : file not found
11:39:57 AM ::: [cqreg has finished with errors]
Cause
When using Microsoft SQL Server database on Linux with IBM Rational ClearQuest, a pre-requisite is to first install the Microsoft SQL Server driver. Microsoft changes the driver version number frequently as well as the corresponding shared object library name (which includes the version number). Because it is not a standardized name, it will be necessary to choose an option to pre-configure or post-configure for your ClearQuest deployment on this platform pairing.
Resolving The Problem
- Install the current latest supported Microsoft SQL Server driver on the Linux host:
https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15#redhat17
Option 1: Before installing ClearQuest - best option as this will handle upgrade scenarios with existing connection profiles and will persist
- cd to the directory containing the Microsoft SQL Server driver typically:
/opt/microsoft/msodbcsql17/lib64/ - symlink from the originally expected driver version name "libmsodbcsql-17.4.so.2.1" to the latest current one you have just installed for example:
ln -s target_file link_name
ln -s libmsodbcsql-17.4.so.2.1 libmsodbcsql-17.6.so.1.1
[root@linuxhost lib64]# ls -ltr
total 2020
-rwxr-xr-x. 1 root root 2065248 Jul 4 04:17 libmsodbcsql-17.6.so.1.1
lrwxrwxrwx. 1 root root 24 Nov 2 10:22 libmsodbcsql-17.4.so.2.1 -> libmsodbcsql-17.6.so.1.1 - Install ClearQuest.
- Note: Any time you plan to upgrade the Microsoft SQL Server driver, please update the symlink to refer to the correct shared object file including the new version number.
Option 2: Post-installation of ClearQuest
- In the installation directory .../clearquest/linux_x86_64/resources/ , you should see 2 files:
cqodbc.ini
cqodbcinst.ini - Change both files and replace this line:
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.4.so.2.1
With this changed value (of your installed SQL Server driver version):
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.7.so.2.1 - Note: Any time you plan to upgrade the Microsoft SQL Server driver, please update the shared object reference in these two files.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"ARM Category":[{"code":"a8m0z000000bn8mAAA","label":"ClearQuest-\u003EDatabases-\u003EMS SQL"}],"ARM Case Number":"TS005993842","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.0.0;9.1.0;and future releases"}]
Product Synonym
CQ; MSSQL;
Was this topic helpful?
Document Information
Modified date:
03 March 2023
UID
ibm16468257