HDBSetup error [unixODBC][Driver Manager]Data source name not found and no default driver specified
Article ID: 135810
Updated On:
Products
Issue/Introduction
We upgraded SCM from v14.0 to v14.5.01. All the installation steps completed successfully, we went to HDBSetup and tried to configure the new ODBC Data Source. During the connection test, the following error message was returned:
0 [unixODBC][Driver Manager]Data source name not found and no default driver specified
It then complained that it could not find ora28.so in my odbc/lib file.
Environment
Harvest Software Change Manager: 14.5 and up
Only affects the Linux/Unix platforms
Cause
This happened because a new type of ODBC driver from a different vendor was adopted for use with the new version of SCM. The customer had only installed the SCM component without also upgrading CAPKI, ODBC, and PEC components
Resolution
After installing the CAPKI, ODBC, and PEC components that were included with the SCM v14.5 installation package, the problem went away.
Additional Information
It is a best practice to always install all components when upgrading Harvest to a new version on the Linux and Unix platforms.
Detailed instructions for installing SCM v14.5 can be found here: Install SCM Server V14.5 component on Redhat Linux 8.x
Feedback
