topic Re: SAS VIYA can`t connect to ODBC Driver in Administration and Deployment

SAS VIYA can`t connect to ODBC Driver

Matt3 — Fri, 16 Nov 2018 10:59:23 GMT

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.

Re: SAS VIYA can`t connect to ODBC Driver

alexal — Fri, 16 Nov 2018 11:59:54 GMT

@Matt3,

I'm wondering to see your odbc.ini

Re: SAS VIYA can`t connect to ODBC Driver

Matt3 — Fri, 16 Nov 2018 12:13:40 GMT

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

Re: SAS VIYA can`t connect to ODBC Driver

Matt3 — Fri, 16 Nov 2018 14:05:06 GMT

Resolved: