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

asked 24 Feb '12, 05:05

deno's gravatar image

deno
11
accept rate: 0%


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?

link

answered 25 Feb '12, 21:44

biyectivo's gravatar image

biyectivo
461
accept rate: 20%

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

link

answered 27 Feb '12, 08:41

deno's gravatar image

deno
11
accept rate: 0%

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

link

answered 03 Mar '12, 15:15

biyectivo's gravatar image

biyectivo
461
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×19
×19
×3
×3
×1

Asked: 24 Feb '12, 05:05

Seen: 1,579 times

Last updated: 03 Mar '12, 15:15

powered by OSQA