In the SAS documents , its showing MSSQL connection can be established by odbc driver and odbc is installed by default in sas deployment. I have used Use Kustomize PatchTransformers to attach the storage with your configuration files to SAS Viya. Within the $deploy/sas-bases/examples/data-access directory, in these example files i have configured mount paths i.e, data-mounts-cas.sample.yaml , data-mounts-deployment.sample.yaml , and data-mounts-job.sample.yaml and configured env variables in sas-access.properties but here when im trying to establish connection of MSSQL datasource in CAS im getting following issue ERROR: ERROR: [DataDirect][ODBC lib] Driver Manager Message file not found. Please check for the value of InstallDir in your odbc.ini - Do we need to install ODBC drivers in Viya accessclients mount path or need to configure host ,port and DSN of MS SQL in odbc.ini - Do we need to open port of MSSQL datbase to k8s cluster nodes of sas viya Please suggest me here. Thanks in advance.
... View more
