Date:         Wed, 10 Nov 1999 13:37:23 -0500
Reply-To:     "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU>
Organization: Duke Clinical Research Institute
Subject:      Re: PC SAS 6.12 accessing PC Oracle V7 database
Content-Type: text/plain; charset=us-ascii

SAS Access to Oracle is needed.
SAS Access to ODBC may also work, if you also have an Oracle ODBC
driver.  Note that the 'SAS ODBC driver' is different from 'SAS Access
to ODBC'; SAS ODBC driver allows other applications to read SAS
datasets, not SAS to read other apps via ODBC.

You will generally get better performance with the SAS Access to Oracle
(and maybe more features), but the SAS Access to ODBC allows more types
of databases.

California Doll wrote:

> Help, it has been a while.  Can this be done with the SAS ODBC and
> ACCESS to PC file formats or will I need the PC ACCESS to ORACLE
> product.  I need to run a proc compare for SAS datasets against the
> Oracle tables.
>
> Thanks in advance.
>
> Vicki
> --
> California Doll
> It takes time to be a success,
>   but time is all it takes.
>         - Anonymous
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
Lawrence H. ('Doc') Muhlbaier           muhlb001@mc.duke.edu
Assistant Research Professor
Duke University Medical Center          919-668-8774 (office)
DUMC 3865                               919-383-0595 (home)
Durham, NC 27710-7510                   919-668-7057 (FAX)