topic Re: how to create microsoft server library . in SAS Programming

how to create microsoft server library .

MG18 — Mon, 09 Jan 2017 07:57:27 GMT

What are neccessary step to create a SAS library for microsoft server ?

I have created one but it is giving following error :-

ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data source name not found and no default driver specified
ERROR: Error in the LIBNAME statement.

What does it mean or what are the possible reason for above error?

Many thanks in advance

Re: how to create microsoft server library .

LinusH — Mon, 09 Jan 2017 08:54:44 GMT

There are many examples in the documentation/papers on how to do this.

What have you tried? The error alone is not enough to understand your situation.

Re: how to create microsoft server library .

MG18 — Mon, 09 Jan 2017 09:43:31 GMT

i have created first data connection through SAS SMC and then created new library using SAS SMC .

Is this working or not ?

Can you suggest how should i proceed ?

Re: how to create microsoft server library .

LinusH — Mon, 09 Jan 2017 10:17:15 GMT

First step: make it work from outside SAS first (but from the same host), i.e. using Excel.

Re: how to create microsoft server library .

SASKiwi — Tue, 10 Jan 2017 07:30:38 GMT

I find it easiest to get a LIBNAME statement working successfully first and then use that as my basis to create an SMC data library. Please post the LIBNAME statement that is giving you the error.

Re: how to create microsoft server library .

MG18 — Tue, 10 Jan 2017 11:22:26 GMT

I have tried to run below libname :-

LIBNAME SAS_MS SQLSVR datasrc="172.31.15.3:1433/JXX_XXX_EXT" SCHEMA=DBO user='misXXX' password='XXXXX';

and i have added entry for sqlsvr in odbc.ini and then tried below libname:-

LIBNAME SAS_MS SQLSVR Datasrc=MSDATA_PROD SCHEMA=DBO AUTHDOMAIN="AUTH_MSSQL" ;

Am i doing right or not ?

Re: how to create microsoft server library .

MG18 — Mon, 23 Jan 2017 07:32:35 GMT

I have followed below link and able to create library.

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/64205/PDF/default/config.pdf