We just added ACCESS to SQL Server on our linux installation. We installed odbc drivers in linux and we connect to destination database universal@gu01sasdi.seguros.local:/home/universal>isql InteligenciaComercial17 sql_admin XXXXXXX -v +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> but when we try to connect using libname from SAS libname azdescom sqlsvr datasrc=InteligenciaComercial18 schema=UNIPROFIT user=sql_admin password="XXXXX" CONNECTION=SHARED insertbuff=30000 readbuff=20000 trace=yes tracefile="/home/universal/odbc.log"; we got the following error ERROR: CLI error trying to establish connection: [unixODBC][Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired : [unixODBC][Microsoft][ODBC Driver 18 for SQL Server]TCP Provider: Error code 0x2AF9 ERROR: Error in the LIBNAME statement.
I just opened a support track with SAS
Have you tested SAS/ACCESS to SQL Server with any other database and does it work? If so then you have a connection-specific problem and Tech Support is your best option so it's great that you have already opened a track.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.