BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Matt3
Quartz | Level 8

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.

 

 

 

error.jpgconf.pngisql.png

1 ACCEPTED SOLUTION

Accepted Solutions
3 REPLIES 3
alexal
SAS Employee

@Matt3,

 

I'm wondering to see your odbc.ini

Matt3
Quartz | Level 8

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
Quartz | Level 8

Resolved:

 

fixed1.pngfixed2.png

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 4232 views
  • 2 likes
  • 2 in conversation