|
Hi, One of my SQL Sever's isn't on the SAS server list. Is there a way to add it. IT can't find a solution. It hasn't been on the list since I started 3 weeks ago. I do have access to the Server in question and use it daily in SQL Express. Any help appreciated. Thanks Den |
|
Hi, When you say 'my SQL Server's isn't on the SAS server list', what exactly do you mean? Are you on a Windows standalone installation or on a server? Normally you'd access a SQL server via a library configured with SAS/Access to SQL Server connector. Can you provide more details please? |
|
Hi, I have enterprise and base sas. It's Enterprise that doesn't have a particular SQL server listed and won't work with proc sql either. Also it's not listed on the SAS main library. Enterprise just returns an error that the libname doesn't exist. SAS base will work fine for this server. Thanks Denis |
|
Depending on the SAS/Access product, you will need to reconfigure the library in Enterprise Guide. The general syntax is: LIBNAME SQL ODBC DSN=’sql server’ user=myuser pw=mypass; where 'sql server' needs to be replaced by the name of the server in the Windows ODBC Adminsitrator. More information here: http://support.sas.com/techsup/technote/ts765.pdf |
