Desktop productivity for business analysts and programmers

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

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 148
Accepted Solution

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

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


assign_project_library.PNG

Accepted Solutions
Solution
‎05-16-2017 03:41 PM
SAS Employee
Posts: 93

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

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)

DatabaseSystem.JPG

 

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

View solution in original post


All Replies
Solution
‎05-16-2017 03:41 PM
SAS Employee
Posts: 93

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

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)

DatabaseSystem.JPG

 

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

Frequent Contributor
Posts: 148

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

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

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 353 views
  • 1 like
  • 2 in conversation