Date: Wed, 16 Feb 2011 09:52:53 -0800
Reply-To: "Pardee, Roy" <pardee.r@GHC.ORG>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Pardee, Roy" <pardee.r@GHC.ORG>
Subject: Re: Getting SAS 9.2 on local PC to interact with MS SQL Server
Content-Type: text/plain; charset="iso-8859-1"
FWIW--this sort of libname statement works for me:
libname mssql OLEDB
properties=("Integrated Security"=SSPI "Initial Catalog"=my_database_name) ;
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Irin later
Sent: Wednesday, February 16, 2011 9:10 AM
Subject: Getting SAS 9.2 on local PC to interact with MS SQL Server 2005
Currently we have SAS 9.2 installed on my local machine and I am unable to access corporate DW which is located on MS SQL Server 2005.
I am trying getting SAS 9.2 to interact with MS SQL Server 2005 through ODBC connection.
SAS /ACCESS Interface to ODBC as well as SAS /ACCESS Interface to PC files are part of our license.
So far my questions are the followings:
-How can I set up SAS driver (SAS /ACCESS Interface to ODBC)?
-Also I am not sure what the name of my SAS Server....Is there any SAS proc with which I can get this name?
-How can I get SAS to interact with our DW through 'libname .. odbc? What kind of setting are needed?
Thank you in advance,
GHC Confidentiality Statement
This message and any attached files might contain confidential information protected by federal and state law. The information is intended only for the use of the individual(s) or entities originally named as addressees. The improper disclosure of such information may be subject to civil or criminal penalties. If this message reached you in error, please contact the sender and destroy this message. Disclosing, copying, forwarding, or distributing the information by unauthorized individuals or entities is strictly prohibited by law.