Hi ,
Altair SLC is running on a server where SAS9.4 is installed. SAS Access To SQL SERVER is under licence at my site. SAS Access to Server is in fact using on Linux an ODBC connection, SAS provides its customers with a Data Direct Acces ODBC driver.
After numerous efforts , I was able to define the LD_LABRARY_PATH for my SLC session on the Linux Server.
Contents of the environment variable : /tools/list/oracle/product/client64/19.8.0/lib:/app/list/data/sasbin/AccessClients/9.4/SQLServer/lib:/app/list/data/altairbin/altairslc-5.24.2.0.1334-ga-release/bin
When trying to connect a SQL Server database , I get the following error
169 ODS HTML(ID=WBHTML) BODY=WPSWBHTM GPATH="/app/list/data/saswork/altairwork/WPS_work964
169 ! 20012e9fa_lr087app10007";
ERROR: A database error occurred. The database specific error follows:
DB: :
170 LIBNAME CAMARSQL SQLSVR Datasrc=CAMARE7 SCHEMA=dbo USER=capilmaj01 PASSWORD=XXXXXX
170 ! X ;
ERROR: Could not connect to DB
171 quit; run;
I am able to access this SQL Server database with SAS Enterprise Guide.
Is what I'am trying to perform possible ? What should I check eventually ?
Any clue welcome.
