Date:         Thu, 27 Jul 2006 12:59:07 -0400
Reply-To:     Michael Ni <Michael.Ni@COGNIGENCORP.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Michael Ni <Michael.Ni@COGNIGENCORP.COM>
Subject:      Re: ADO/OLE
Comments: To: "Pardee, Roy" <pardee.r@ghc.org>
In-Reply-To:  <8AD8F86B3312F24CB432CEDDA71889F201B5C4CB@ex06.GHCMASTER.GHC.ORG>
Content-Type: text/plain; charset=us-ascii

Roy,

Thanks so much for your detailed answer!

Michael

Pardee, Roy wrote:

>OLEDB ('object linking/embedding for databases') is a microsoft
>technology (windows-specific on the client side) aimed at providing
>'universal data access'--a single interface for moving data to/from all
>sorts of different sources (mostly databases, but not exclusively).
>It's sort of an updated & generalized ODBC.
>
>ADO ('activex data objects') is layer on top of OLEDB--it's a simpler
>API that drives OLEDB for you.
>
>If you've got sas/access for oledb licensed, you can use it to get at
>all kinds of diverse data sources (so long as you're running on the
>windows platform).  But it's not an interface to e.g., call VB or java
>programs & return their results.  I believe sas has APIs set up both for
>java and plain old OLE (search the archives for most any message with
>'excel' in the subject--or just wait a couple of days and someone else
>will post a new question about how to move data into excel & someone
>will post that wacky-looking OLE code ;-).
>
>And of course you can always shell out to command-liney stuff w/the x()
>command or a pipe...
>
>HTH,
>
>-Roy
>
>-----Original Message-----
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>Michael Ni
>Sent: Thursday, July 27, 2006 8:06 AM
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: ADO/OLE
>
>Hi SAS Experts,
>
>Could anyone tell me whether ADO/OLE is the module to connect SAS to
>other languages (Java, VB, etc.)? Or there is other modules in SAS?
>
>Thanks a lot!
>
>Michael
>
>