Date:         Fri, 8 Sep 2000 17:09:29 -0700
Reply-To:     Cassell.David@EPAMAIL.EPA.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "David L. Cassell" <Cassell.David@EPAMAIL.EPA.GOV>
Subject:      Re: sas Access to lotus notes (odbc) set-up
Content-type: text/plain; charset=us-ascii

Jeff Lesueur wrote:
> anyone experienced in setting up sas Access to lotus notes ?  i've

I can't say that I'm *experienced* here, but I can tell you a couple things.
Lotus Notes is accessible via either ODBC or OLE.  If you need to go the
ODBC route, there used to be NotesSQL drivers on the Lotus website which
would do the job.  I don't know if they're still there [and free].

> installed sas access (odbc) on a unix platform, the Notes database
> is on an NT platform.

Of course.  It's *always* on an NT server.

>                                            lotus is saying that additional
software is
> required on both the unix platform as well as the NT platform (and they
> want $$$ for this software).

Of course!!!  If you have SAS on a unix box, I think you'll have to go with
the ODBC route.  And if you cannot get the NotesSQL drivers from their
website and you have to use ODBC, there will be no alternative but to buy
from them the drivers.  Sorry.

It is probably easier to go the OLE route.  [It might be possible to do it via
LDAP
too.]  You could try accessing the Notes databases using OLE in a programming
language such as Visual Basic, Java, or Perl, then transferring [in an
unspecified
way] the information over to the unix box for SAS processing.

In Perl the OLE route is as easy as 1-2-3 [sorry about the pun :-] :

use Win32::OLE;
use Win32::OLE::Variant;
my $session = Win32::OLE::new->('Notes.NotesSession') or die "Doggone Lotus
Notes!  $!";

Of course there's more needed to open the desired database, get the view you
want,
iterate over all the documents in the view, etc.  But you can get there via OLE
and
it may be cheaper - even if it is less direct.  You'll have to decide on
optimality
criteria.

David
--
David Cassell, OAO Corp.                           Cassell.David@epa.gov
Senior computing specialist
mathematical statistician