Date: Tue, 21 Jul 2009 14:08:07 -0400
Reply-To: "O'Connell, Martin" <MOConnell@GEICO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "O'Connell, Martin" <MOConnell@GEICO.COM>
Subject: SAS/EG connection to SQL Server
Content-Type: text/plain; charset="us-ascii"
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
libname SQLv sqlsvr dsn=UPM_Product_Mgmt uid=sassql01 pwd="&sql01pw."
libname SQLc sqlsvr dsn=UPM_Product_Mgmt uid=sassql01 pwd="&sql01pw."
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
Thanks for any help.
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.