I used this code to connect to an outside SQL server and it seems to have worked:
libname odbclib odbc noprompt="Driver={SQL Server};
369 Server=10.100.100.100 ;
370 Database=XXXwork;
371 Uid=;
372 Pwd=;"
373 ;
NOTE: Libref ODBCLIB was successfully assigned as follows:
Engine: ODBC
Physical Name:
Can someone tell me how to get table and column names from the server now?