How to derive my proc sql connection string from libname connection string?

[saspert]

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

[DBailey]

Have you tried:

connect using WWtest as cWWTest;

[saspert]

This is a more OS -related issue as per my supervisor. So we can ignore this for now. Thanks! 

[SASKiwi]

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.

[saspert]

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.

[SASKiwi]

In that case your same NOPROMPT string should work fine in a CONNECTION statement.