configure sasenv_local for two different ODBC drivers

freshstarter — Tue, 15 Oct 2024 11:47:25 GMT

Hello,

Recently I have installed snowflake odbc driver on linux server and already we had sql server odbc driver installed. Now we have two different odbc.ini file. I have included all the connection parameters in the new odbc.ini file relates to snowflake and updates the library path in sasenv_local file. The connection to snowflake is working fine from SAS libname statement. But the connection to SQL server is not working.

I defined the values as like below

export ODBCHOME:/sas/AccessClients/9.4/SQLServer:/etc

export LD_LIBRARY_PATH:$ODBCHOME/lib:/etc/snowflake_ODBC/lib:/usr/lib64:$LD_LIBRARY_PATH

export ODBCINI:/sas/AccessClients/9/4/SQLServer/odbc.ini:/etc/odbc.ini

export ODBCINST:/sas/AccessClients/9/4/SQLServer/odbcinst.ini:/etc/odbcinst.ini

export SIMBAINI:/etc/snowflake_ODBC/lib/simba.snowflake.ini

/etc is where snowflake driver is installed and SQLServer is under /sas/AccessClients.

Kindly suggest how to edit this file to have both the connection working properly. Thanks

Re: configure sasenv_local for two different ODBC drivers

Sajid01 — Thu, 17 Oct 2024 15:31:17 GMT

Hello
The issue appears to be the syntax.
I would prefer to write your content in sasenv_local as follows.

export ODBCHOME=/sas/AccessClients/9.4/SQLServer:/etc
export LD_LIBRARY_PATH=/sas/AccessClients/9.4/SQLServer/lib:/etc/snowflake_ODBC/lib:/usr/lib64:$LD_LIBRARY_PATH
export ODBCINI=/sas/AccessClients/9/4/SQLServer/odbc.ini:/etc/odbc.ini
export ODBCINST=/sas/AccessClients/9/4/SQLServer/odbcinst.ini:/etc/odbcinst.ini
export SIMBAINI=/etc/snowflake_ODBC/lib/simba.snowflake.ini

I assumed that the lib folder for sql server is at /sas/AccessClients/9.4/SQLServer/lib.
If not please make appropriate changes.
I would recommend that whenever you make changes to this file, get it validated by the Linux Admin for syntax.

topic configure sasenv_local for two different ODBC drivers in Administration and Deployment

configure sasenv_local for two different ODBC drivers

Re: configure sasenv_local for two different ODBC drivers