SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

oracle ODBC Library not showing up in SAS DI Studio 4.9

Reply
Super Contributor
Posts: 269

oracle ODBC Library not showing up in SAS DI Studio 4.9

[ Edited ]

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.


missinglib_sasdistudio4.9.png
Super User
Posts: 3,115

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

Do the ODBC libraries appear in the EG server window?

 

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

Super Contributor
Posts: 269

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

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

Super User
Posts: 5,260

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

I think @SASKiwi ment to run it in DI Studio...
What is the assignment method?
Also look for authorization.
Data never sleeps
Super Contributor
Posts: 269

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

ERROR: Libref CPMLIB is not assigned

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

Super User
Posts: 3,115

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

@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. 

Ask a Question
Discussion stats
  • 5 replies
  • 323 views
  • 0 likes
  • 3 in conversation