Thank you for your reply. I have done the following post your reply:- - Added my user ID as a sudo user in RHEL 7.9 server - Made the server rebooted - Enabled internet access and created a directory /sas/databricks-odbc - Downloaded the Databricks ODBC Simbaspark driver which came in zipped format before unpacking to "simbaspark_2.9.1.1001-l.x86_64.rpm" - Went to "root", with "sudo su", navigated to the above directory and unzipped the zip file into .rpm file - Verified that unixODBC-2.3.7-l.rh.x86_64 is present in the server - odbcinst -q -d shows [Simba Spark ODBC Driver] & [MSSQL-ODBCXX] - Used sudo tee -a /etc/odbcinst.ini <<'EOF' [Simba Spark ODBC Driver] Description=Simba Spark ODBC Driver Driver=/opt/simba/spark/lib/64/libsparkodbc_sb64.so FileUsage=1 EOF - Verfied using ls -l /opt/simba/spark/lib/64/libsparkodbc_sb64.so : Shows the path in root Now when I am using isql -v "" "Driver=/opt/simba/spark/lib/64/libsparkodbc_sb64.so;Host=;Port=443;HTTPPath=;SSL=1;ThirftTransport=2;AuthMech=3;UID=;PWD=;" I am getting [IM002][unixODBC][Driver Manager] Data source name not found and no default driver specified. [ISQL]Error:Could not SQLConnect Is there anything I am missing here? Do we need to reboot the server again? Am I missing any .env file in /sas/home/ ? Your help would be really appreciated. Thanks in advance.
... View more