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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: