topic Re: oracle ODBC Library not showing up in SAS DI Studio 4.9 in SAS Data Management

oracle ODBC Library not showing up in SAS DI Studio 4.9

saspert — Mon, 22 Aug 2016 19:17:23 GMT

Hello,

I have several SAS Libraries in SAS Management Console 9.4. But only some of them show up in SAS DI Studio 4.9. Should I create a brand new library? I am afraid that it may overwrite an existing library.

Please advise.

Thanks,
saspert.

Re: oracle ODBC Library not showing up in SAS DI Studio 4.9

SASKiwi — Mon, 22 Aug 2016 19:35:01 GMT

Do the ODBC libraries appear in the EG server window?

Try also testing the library in a program: proc contents data = library._all_; run;

Re: oracle ODBC Library not showing up in SAS DI Studio 4.9

saspert — Mon, 22 Aug 2016 19:55:13 GMT

Hi saskiwi,

I can see the sas libraries in SAS EG. In fact they are more or less in sync with SAS MC 9.4 list of libraries. I ran the code without any errors in SASEG. proc contents data=abmlib._all_; run;

Thanks,

saspert

Re: oracle ODBC Library not showing up in SAS DI Studio 4.9

LinusH — Mon, 22 Aug 2016 20:09:51 GMT

I think @SASKiwi ment to run it in DI Studio...
What is the assignment method?
Also look for authorization.

Re: oracle ODBC Library not showing up in SAS DI Studio 4.9

saspert — Mon, 22 Aug 2016 20:40:44 GMT

ERROR: Libref CPMLIB is not assigned

is the error I get if I try to run it in SAS DI studio 4.9

Re: oracle ODBC Library not showing up in SAS DI Studio 4.9

SASKiwi — Mon, 22 Aug 2016 20:57:03 GMT

@LinusH - Actually I did mean EG just to confirm the libnames did work outside of DI Studio.

@saspert - I suggest you compare an ODBC library definition that works in DI Studio versus one that doesn't work. What is different? One area to check is the metadata folder the definitions are stored in - are they the same or not? Different metadata permissions might cause this problem.