Hi All,     If using SAS server in linux, will the SAS admin do network mounts for the convenience of the SAS users?       1) what's the common procedure?       A: share local Windows drive as a network resource and mount it to linux server       B: share a resource on the server and mount it on your desktop       C: use a resource on a file server mounted on both machines (server and desktop)       😧 no network mount     2) How do you share project for multipul people to use?     Thank you! Jade ... View more

Hi All,      I am using SAS server in linux and tried the connection to MS SQL server via ODBC, I got errors. The connection could not be established successfully.   1) When using Libname, no real error message in the log file, but the table I see from SAS library is not the real table in SQL studio (the Table in SAS library seems to have a chopped off name of the real table in SQL studio) A: SAS statement: LIBNAME sqltest odbc Password=** User=** DATASRC=** schema=**; B: Table in SAS library, see attached word file. C: Table in SQL studio, see attached word file.      2) When using pass through, got error message. A: SAS statement: proc sql; connect to odbc (noprompt = "dsn=**;DRIVER=SQLServer;uid=**;pwd=**;"); create table Prod02test as select * from connection to odbc (SELECT * FROM [**].[**].[**] ) ; disconnect from odbc; quit;   B: Error message ERROR: CLI describe error: [   What's the possible reason for that? Is there something wrong from SAS side or SQL side? Thank you!   Jade   ... View more