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
              2005
In-Reply-To:  <418542.4339.qm@web39408.mail.mud.yahoo.com>
Content-Type: text/plain; charset="iso-8859-1"

FWIW--this sort of libname statement works for me:

libname  mssql OLEDB
         provider=SQLOLEDB
         datasource='my_sql_server_name'
         properties=("Integrated Security"=SSPI "Initial Catalog"=my_database_name) ;

HTH,

-Roy

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Irin later
Sent: Wednesday, February 16, 2011 9:10 AM
To: SAS-L@LISTSERV.UGA.EDU
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,
Irin




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.