SAS VIYA can`t connect to ODBC Driver

[Matt3]

Hi,

We`ve just deployed SAS VIYA with SAS Access/ODBC, however when we tried connect to SQL Server DB received following error:

I ve checked connection with odbc by isql and it works.

In attachment you can also find content of our sasenv_deployment and cas_usermods.settings file.

We are dealing with SAS Viya 3.4 on RedHat 7.x

I would be greatefull for any help.

Thank you.

[alexal]

@Matt3,

I'm wondering to see your odbc.ini

[Matt3]

Here it is:

odbc.ini:

[MSSQL_SAS_VIYA]
Driver = ODBC Driver 17 for SQL Server
Description = MSSQL ODBC Driver
Server = tcp:hostip,port 

odbcinst.ini:

[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1
UsageCount=1

[Matt3 · Accepted solution]

Resolved: