Thanks to the following people for their suggestions:
Larry Clegg, Russ Fish, Paul Roetman, Jason Boyles, Jim Jennis and Ed
Notari.
The most popular suggestion was to use Perl and use the DBI::ODBC module. In
this solution, one would install Perl on the UNIX box, Perl on the Windows
box and use the Perl ODBC proxy server to let UNIX Perl ODBC talk to the
Windows box. Another suggestion was to use the freeware unixODBC product. I
did not look into this closely, but it seems to be very similar in function
to the free Intersolv ODBC data access products that are part of Tru64 UNIX.
There is an EAI product from WRQ called Verastream that apparently can do
this. I looked at WRQ's web site and they do not have a single user license
for this product. Given a limited budget, I did not investigate this
product.
George.
----- Original Message -----
From: "George Chalissery" <chalissery_at_hotmail.com>
To: <tru64-unix-managers_at_ornl.gov>
Sent: Tuesday, July 25, 2000 5:27 PM
Subject: Access to Microsoft Access from Tru64 UNIX.
> I am trying to develop a solution using which I can access Microsoft
Access
> databases on a Windows NT/2000 server/workstation from a SAS program
running
> on a Tru64 UNIX box. SAS on Tru64 UNIX does not have the ability to talk
> ODBC, but I am willing to work with a C API or something similar (Perl?
> Tcl?). I am contemplating writing a Win32 console executable in VB and
> passing it the required parameters via a file. The executable will be run
> via a telnet / rsh session on the Windows box and the results passed back
> via a file. Ugly, but the easiest solution that I could come up with given
> my lack of understanding of the networked database connectivity/ODBC
world.
>
> Have you faced this problem and developed a different type of solution
that
> avoids the intermediate files? Any help in the general direction of a
> solution is appreciated. I have visited the Digital UNIX data access page
> and looked at the documentation of the free Intersolv product that is
> available for download, but I don't think those products provide me with a
> solution. I may be mistaken.
>
> Thanks,
>
> George.
Received on Thu Jul 27 2000 - 16:50:58 NZST