SAS Viya 3.5 ODBC MSSQL Connection

[bursalı]

Hi to all,

I installed Viya 3.5 environment. Then, when i try to connect data source via Environment Manager "Data" tab, i got following error;

Content of my odbc.ini file;

[Sajid01]

You appear to have the Data Direct driver for MS SQL Server.
You would also need SAS Access interface to ODBC

[bursalı · Accepted solution]

Thanks for your answer. 

I solved it by adding environment variables to relevant areas such as compute server config files etc.

Just follow; SAS Help Center: Configure Data Access