I have had some success with the Native ODBC SQL Server Driver on SAS 9.3 (On Linux) . We do not use a Libname Statement for extracting data though. We use this method to connect to MSSQL 2014 Server databases: %let connx=(dsn=<myODBC_DSN> user=<MYLOGIN> pwd=xxxxxxx); Proc SQL; connect to odbc&connx; Create Table Test as Select * from connection to odbc (SELECT * FROM [SQLDatabase].[dbo].[MyTable]); Disconnect from odbc; Quit; This method is dependent on a ODNC.ini DSN entry, so you will need to make sure that you have a proper DSN in your ODBC.ini and ODBCINST.ini files on your Linux Server.
... View more