topic Re: error A Connection to the ODBC DBMS is not currently supported in Administration and Deployment

error A Connection to the ODBC DBMS is not currently supported

MaheshRSA — Fri, 19 Jan 2024 16:07:24 GMT

Hi All,

I have installed the new SAS grid on Linux server and getting below error while running to ODBC proc sql . I think have missed the creation of the some variable in Compute server .

Can some help me .

28 proc sql noprint;
29 connect to odbc as st (dsn='LWUKWVTI13BMT' uid='sasgriduser' pwd=XXXXXXXXXXXX);
ERROR: Could not load /sas/grid/software/SASFoundation/9.4/sasexe/sasodb (99 images loaded)
ERROR: libodbc.so: cannot open shared object file: No such file or directory
ERROR: The SAS/ACCESS Interface to ODBC cannot be loaded. The SASODB code appendage could not be loaded.
ERROR: A Connection to the odbc DBMS is not currently supported, or is not installed at your site.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
30 execute (Select * from dbo.stgAAHH) by st;
NOTE: Statement not executed due to NOEXEC option.
31 disconnect from st;
NOTE: Statement not executed due to NOEXEC option.
32 quit;

Re: error A Connection to the ODBC DBMS is not currently supported

gwootton — Fri, 19 Jan 2024 18:07:04 GMT

As this is complaining about a missing library (libodbc.so), I'd suspect an issue with something being done in <SASHome>/SASFoundation/9.4/sasenv_local that is modifying the contents of LD_LIBRARY_PATH incorrectly. I'd also make sure you are providing the necessary environment variables for your ODBC connection (ODBCINI, ODBCINSTINI)

Setting UNIX Environment Variables for SAS/ACCESS
https://go.documentation.sas.com/doc/en/bicdc/9.4/bidsag/p1w3v98qca3sfzn1rzty2tngrfyq.htm

Re: error A Connection to the ODBC DBMS is not currently supported

MaheshRSA — Mon, 22 Jan 2024 08:38:32 GMT

Hi @gwootton ,

I have already edited sasenv_local file as mentioned in the article .

Do I need to install ODBC driver separately ?

PFB below content of it .

# This file is sourced by the sasenv script in !SASROOT/bin
############################################################################

export ODBCHOME=/sas/grid/software/SASODBCDriversfortheWebInfrastructurePlatformDataServer/9.4/
export ODBCINI=/sas/grid/software/SASODBCDriversfortheWebInfrastructurePlatformDataServer/9.4/Driver/odbc.ini
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/sas/grid/software/SASODBCDriversfortheWebInfrastructurePlatformDataServer/9.4/Driver/:/usr/lib/oracle/12.2/client64/lib/:/usr/odbc/lib/
export TNS_ADMIN=/usr/lib/oracle/12.2

umask 0007

############################################################################
# End of sasenv_local
############################################################################

Re: error A Connection to the ODBC DBMS is not currently supported

gwootton — Mon, 22 Jan 2024 16:20:17 GMT

Correct, you would need to first set up the ODBC driver on your compute host before being able to make use of it. You should remove the references to SASODBCDriversfortheWebInfrastructurePlatformDataServer from your sasenv_local, this is specifically for connections to the SAS environment's internal database (the Web Infrastructure Platform Data Server).

ODBC on the UNIX Platform
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n1ht6mv0wybbzkn1x4np6nnlwzu6.htm#n0lqyvb3cfot9hn19u4yn4gcdrkk