01-09-2017 02:57 AM
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
01-09-2017 03:54 AM
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.
01-09-2017 04:43 AM
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 ?
01-10-2017 02:30 AM
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.
01-10-2017 06:22 AM
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 ?
Need further help from the community? Please ask a new question.