DATA Step, Macro, Functions and more

Connect to remote SQL server

Reply
Contributor
Posts: 20

Connect to remote SQL server

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?
Trusted Advisor
Posts: 2,113

Re: Connect to remote SQL server

try this
http://support.sas.com/kb/15/721.html
I searched for on support.sas.com
Ask a Question
Discussion stats
  • 1 reply
  • 143 views
  • 0 likes
  • 2 in conversation