If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide

[FabioP]

If I Pre-Assign an Oracle Library with the Management Console, It disappear in EGuide.

I have not set the AssignMode property in the "Extended Attributes" in the Library property. 

I have a similar Oracle Library for a different Oracle Schema in the same path, and with that library I have no problem at all.

Can you help me?

Thanks!

[Linlin]

Hi,

try :

click tools ---> options ---> SAS Program ---> Submit code when server is connected ---> edit

then copy you libname code there

[FabioP]

Hi Linlin,

thank you!

It's a good workaround, but I can't understand why I can't see the library in EG that is preassigned in the Management Console.

If in MC I clear the preassign option, the library return visible in EG, but then I have to manually assign it in EG (unless I use your workaround)

[sas_9 · Accepted solution]

Hi Fabio, couple of things to make sure:

- delete it and create again

- make sure you assign library as pre-assigned "bynative library engine"

- make sure when you provide information for

- on "assign" tab

selected server would be "sasapp"

- on data server tab

data server

database schema name

connection

-also keep liname and liref name same

[FabioP]

Hi Sandy,

thank you very much!

I set the name of the library in the metadata  same as the libref and now is working.

Only a clarification, where is it possible to assign library as pre-assigned "bynative library engine"?

Thanks!

[sas_9]

when you open SAS  MC, Plug-Ins>Data Library Manager> then click on "library"> then double click on library which you wants to assign as pre-assigned to view property of library> go to options>click on advance options

.

[FabioP]

Hi Sandy, thanks for your great help!

[seven_snow]

Hi, Just in case does anyone know how to pre-assign a SAP R3 library in SMC. After following the above steps, SAP R3 library does not have "Advance Options" where we usually pre-assign. Please advise.

[twocanbazza]

what version of EG and SAS etc are you using?

[FabioP]

sas 9.2 with guide 4.3