Loading

Unable to connect SQL database after upgrading the SQL ODBC driver on Linux

Date de publication: Mar 24, 2025
Description

After updating the SQL ODBC Driver on Linux Machine, unable to connect the Data source with the error:

"Could not connect to the server "

The installation is successful but unable to connect to the Data source.

Cause

The dependency packages were missing for the ODBC driver.
Résolution
  • Verify the permissions of the SO file (example: libmsodbcsql-17.2.so.0.1) and make sure the user has full permissions.
  • Check the dependency packages of the SO file and verify with the below command if there is any dependency package is missing. (ldd command checks the dependency and report any missing objects.)
    • ldd /opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1 (File name will be changed based on the version)
If there are missing files, reinstall the ODBC driver package.
Ressources supplémentaires
You will see the following error in vizportal logs when you try to test the connection to the data source if there are missing files.

"msg":"\"There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs.\n[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1' : file not found\n\"","type":"ConnectivityException"},
 
Numéro d’article de la base de connaissances

001475441

 
Chargement
Salesforce Help | Article