Date: Thu, 19 Jun 2008 09:53:47 -0700
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: SQL Enterprise connection question
Content-Type: text/plain; charset="us-ascii"
Here's what I use here, where we have sas/access for OLEDB and ODBC
licensed on different platforms:
libname mssql ODBC required = "DRIVER=SQL
libname mssql OLEDB provider=SQLOLEDB datasource='ctrhs-dbserver'
properties=("Integrated Security"=SSPI "Initial Catalog"=Pathology)
You'll need to change those server & catalog/db names of course.
Also, FWIW--*SAS* should not need the libname to have any particular
name--you should be able to call them whatever you like. You may have
SAS code that uses a particular name, but I don't think there's anything
magic about that.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ben
Sent: Thursday, June 19, 2008 4:45 AM
Subject: SQL Enterprise connection question
Where I'm working we currently create several DTS packages for each of
studies in SQL Enterprise to create different csv files of the study
data. We have SAS/ACCESS licence and I am looking to use this to read
the SQL tables direct to SAS to create an instant data cut.
I've tried looking this up but it seems I need to use a libname
statement defined as 'sqlsvr'. My problem though is I don't know what
options I need or how to reference the databases from here. Can anyone
give me an overview on how to do this?
Many thanks in advance!