Hi Timmy, Yes, I had already done that. but, still some thing went wrong in the configuration (it looks like). Could you please check if the way I have defined the paths is correct or not. under cas.settings: export ODBCINI=/etc/odbc.ini export ODBCINSTINI=/etc/odbcinst.ini export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/data/denodoodbc-09.03.0420/lib/   and under sasenv_local: export ODBCINI=/etc/odbc.ini export ODBCINSTINI=/etc/odbcinst.ini export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/data/denodoodbc-09.03.0420/lib/   Am i missing anything else? Note: I have placed the .ini files at /etc.Thanks!! ... View more

Is this the one that you are expecting me to share? cat caslaunch_default_controller_daemon.log 2017-12-13T15:53:41 gspdsv04.aqua.local:0: NOTE: The list of machines in '/opt/sas/viya/home/SASFoundation/../../config/etc/cas/default/cas.hosts' will be ignored because the server is running in SMP mode. === CAS gspdsv04.aqua.local:5570 (0) http://gspdsv04.aqua.local:443 === [root@gspdsv04 default]# cat caslaunch_default_controller_daemon.err 2017-12-13T19:46:31 gspdsv04.aqua.local:0: ERROR: Could not find the specified session. Previously I had sent you another log "cas_2017-12-15_gspdsv04_1103.log" ... View more

Yes Alex, I had done that. Here is the program that I had run. cas mySession sessopts=(caslib=casuser timeout=1800 locale="en_US"); caslib odbclib datasource=(srctype="odbc" username="sas_odbc_user" password="xxxxxxxxxxxxxxxxxx" odbc_dsn="VDP_acme_DSN"); proc casutil; list files incaslib=odbclib; run; And getting error as below: ERROR: The connection to the data source driver failed. ERROR: No diagnostic records were returned. ERROR: Function failed. ERROR: The action stopped due to errors. ... View more

Hi Alex, Can I have any help on this please. Thanks!! ... View more

Hi Alex,   Please find the log here. Kindly have a look at it and suggest us. Thanks!!     ... View more

Okay.. its alraedy a service available at /etc/init.d. So I had restarted it. Will send the log in a while. Thanks!! ... View more

Thanks Alex!! I have added the logger to the xml. Now, to restart the cas server, Should I setup the cascontroller to run as a service? ... View more

Hi Alex,   Sorry, Have semt you the wrong files. Please find the correct files here. Thanks, Sri     ... View more

Okay. Please find them here. Thanks!! ... View more

And here is the LD_LIBRARY path in the attachment. Thanks!! ... View more

Hi Alex, I have checked it. And the values are as follows: ODBCINI /etc/odbc.ini ODBCINSTINI /etc/odbcinst.ini ... View more