topic how to assign library via "assign project library" in EG? in SAS Enterprise Guide

how to assign library via "assign project library" in EG?

Jade_SAS — Wed, 10 May 2017 14:48:03 GMT

Hi All,

a qucik question, has anyone tried to use the "assign project library" in SAS EG for sql data access? I tried and it does not work for me,

For example, the following library coding works,

LIBNAME sqltest ODBC USER="***" PASSWORD="***" DATASRC="a1-b2" SCHEMA=dbo;

But if I want to get the above connection using "assign project library", what information I should fill in the attached window that needed in the process? I do not know what should fill in for server. I tried to use "a1-b2" for server, but failed.

Any comments on this?

Thanks,

Jade

Re: how to assign library via "assign project library" in EG?

Damo — Tue, 16 May 2017 14:30:54 GMT

Hi Jade,

The Database Server should not be empty as it will pick automatically one of the server defined in your Metadata.

This is the content extracted from the EG log (you can also access it from the interface and the HELP button if the definition is not good enough)

The relevant extract confirming that the list should not be empty is that one:

The drop-down list displays the database servers that have been defined in the active SAS Metadata Repository. If the server that you want to use is not defined in the metadata, then that server does not appear in the drop-down list. Your administrator can use SAS Management Console to define additional servers.

If you are using EG with a Metadata Server, you'll need to add that definition, using the SAS Management Console.

This would be a task for your SAS administrator.

Cheers,

Damien

Re: how to assign library via "assign project library" in EG?

Jade_SAS — Tue, 16 May 2017 19:43:00 GMT

Thank you, my admin just added the database so that I finally have a drop list in EG!