BookmarkSubscribeRSS Feed
ravi15
Calcite | Level 5

Hi i am seeing the below error intermittently. not sure what the issue is. 

 

Any help on this is much appreciated. 

 

ERROR: CLI error trying to establish connection: [SAS][ODBC SQL Server Legacy Driver]Timeout expired

ERROR: Error in the LIBNAME statement.

 

Thank you.

2 REPLIES 2
SangramjitPanda
Obsidian | Level 7

Some important notes:

 

1. Do you have SAS/Access engine for ODBC?

2. Have you installed the ODBC driver on the Compute Tier?

3. If yes, did you edited the odbc.ini file and include the DataSrc information?

4. If above setting are completed, confirm if the service account used to connect to the Database has the required permission to access.

 

 

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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 25251 views
  • 1 like
  • 3 in conversation