Hi guys,
My libname is here -
LIBNAME WWTest ODBC NOPROMPT="server=HMIDWPRD03;driver=sql server;Trusted Connection=yes;Database=WW;" SCHEMA=dbo USER=myid PASSWORD="{sas002}secretalphanumericcode123" ;
I tried several kinds of combinations for proc sql but it will not work -
23 Proc sql;
24 Connect to odbc ( user=myid password=myunecryptedpwd database="WW.dbo") ;
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver
specified
I tried datasrc=/ database= /single quote/double quote/ and other combinations but of no avail.
Thanks,
saspert
Have you tried:
connect using WWtest as cWWTest;
This is a more OS -related issue as per my supervisor. So we can ignore this for now. Thanks!
Does your LIBNAME actually work? Supplying a username and password is not required if you are using Windows authentication as your string Trusted Connection=yes; indicates. With this option SQL Server authenticates against your Windows user credentials.
LIBNAME WW2 ODBC NOPROMPT="server=ABCDEFGPRD;driver=sql server;Trusted Connection=yes;Database=WW;" ;
This works fine. The original library is WW. The new test library I created is WW2. Both are shown as assigned/created.
In that case your same NOPROMPT string should work fine in a CONNECTION statement.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.