Hi all,

I'm trying to configure a connection from PC EG to SQL Server databases via SASMain running on unix server. We are connecting from EG to SASMain through Integration Technologies. I'm able to connect to read-only production databases fine but am having problems creating libnames that connect to user schemas. It seems that we have to create two libnames:

libname SQLv sqlsvr dsn=UPM_Product_Mgmt uid=sassql01 pwd="&sql01pw." schema="windowsdomain\user";

libname SQLc sqlsvr dsn=UPM_Product_Mgmt uid=sassql01 pwd="&sql01pw." schema="[windowsdomain\user]";

The first libname allows us to see what tables are in the schema and the second allows us to develop against those tables. In other words, each libname does one but not the other (metadata browsing and data access).

Can we have a single libname that will allow both (metadata browsing and data access)?

Thanks for any help.

Martin

==================== This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message.