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
Content-Type: text/plain; charset=us-ascii
Thanks so much for your detailed answer!
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...
>From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>Sent: Thursday, July 27, 2006 8:06 AM
>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!