https://communities.sas.com/t5/SAS-Programming/Connect-to-remote-SQL-server/m-p/19778#M3058 I used this code to connect to an outside SQL server and it seems to have worked:<BR /> libname odbclib odbc noprompt="Driver={SQL Server};<BR /> 369 Server=10.100.100.100 ;<BR /> 370 Database=XXXwork;<BR /> 371 Uid=;<BR /> 372 Pwd=;"<BR /> 373 ;<BR /> NOTE: Libref ODBCLIB was successfully assigned as follows:<BR /> Engine: ODBC<BR /> Physical Name:<BR /> Can someone tell me how to get table and column names from the server now? Thu, 19 Nov 2009 22:08:58 GMT Marilyn 2009-11-19T22:08:58Z https://communities.sas.com/t5/SAS-Programming/Connect-to-remote-SQL-server/m-p/19778#M3058 I used this code to connect to an outside SQL server and it seems to have worked:<BR /> libname odbclib odbc noprompt="Driver={SQL Server};<BR /> 369 Server=10.100.100.100 ;<BR /> 370 Database=XXXwork;<BR /> 371 Uid=;<BR /> 372 Pwd=;"<BR /> 373 ;<BR /> NOTE: Libref ODBCLIB was successfully assigned as follows:<BR /> Engine: ODBC<BR /> Physical Name:<BR /> Can someone tell me how to get table and column names from the server now? Thu, 19 Nov 2009 22:08:58 GMT https://communities.sas.com/t5/SAS-Programming/Connect-to-remote-SQL-server/m-p/19778#M3058 Marilyn 2009-11-19T22:08:58Z https://communities.sas.com/t5/SAS-Programming/Connect-to-remote-SQL-server/m-p/19779#M3059 try this<BR /> <A href="http://support.sas.com/kb/15/721.html" target="_blank">http://support.sas.com/kb/15/721.html</A><BR /> I searched for <ODBC table="" list=""> on support.sas.com</ODBC> Thu, 19 Nov 2009 23:41:01 GMT https://communities.sas.com/t5/SAS-Programming/Connect-to-remote-SQL-server/m-p/19779#M3059 Doc_Duke 2009-11-19T23:41:01Z