Below is a reply I made to someone wanted to access Oracle on NT from a
Linux box (client perl pgm). The same situation could apply to accessing MS
Access from a Unix or Linux machine. Why fool around with installing ODBC
drivers on Unix/Linux when you have a great pass-through facility like
DBI:Proxy??
Again, I ask the group if I'm missing something here with this approach.
Mark
************************* earlier reply ******************************
I have a similar situation here with my Oracle 8i database residing on W2k
and my client Perl program running on a Linux/RedHat 7.2 machine. After
reading about how DBI:Proxy works, I took the existing Perl program and
changed the connect to look like this:
################### Build Connect Parameters
####################################################
my $proxy = "hostname=xxx.xxx.x.xxx;port=4444";
my $dsn = 'dbi:ODBC:Ora_Northwind';
my $user='mark';
my $password='xxxx';
my $dbh = DBI->connect("dbi:Proxy:$proxy;dsn=$dsn", $user, $password)
or die "Can't connect to database ", DBI::errstr," \n";
print "We have connected successfully to the Windows 2000 Oracle NorthWind
Database via ODBC \n";
############################################################################
######################
Having done this, I realized the following about the usefulness of
DBI::Proxy
1. I can distribute the Perl client to any machine in my network and not
have to fool around with Oracle Connect
Libraries (you do need the DBI component).
2. I could manage the connectivity at the server (NT) fairly easy and
dynamically with the Dbiproxy script.
Am I missing anything here? Or is it as simple as this?
Mark
-----Original Message-----
From: Erick Nelson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 25, 2002 8:41 AM
To: Bart Lateur
Cc: DBI-Users
Subject: Re: MS Access
Thanks,
But this is not being done on a Win32 box. Does anybody know how I go about
getting an ODBC driver for Sun Solaris ?
Bart Lateur wrote:
> On Mon, 24 Jun 2002 16:22:38 -0700, Erick Nelson wrote:
>
> >I've just spent the last 15 minutes looking at CPAN for a module to
> >query a MS Access database.
> >Which modules do I need to download?
>
> You need DBD::ODBC.
>
> >Can someone throw me a hint? :)
>
> Well: first create a DSN for the database using the ODBC control panel
> (comes with Windows). You can simply use the name that you used for it
> there, to connect to the db in the connect string. Just look at these
> FAQ entries:
>
> I need to define a DSN for ODBC, how do I do it and which type should I
> use?
> <http://xmlproj.dyndns.org/faqomatic/cache/6.html>
>
> Example of DBD::ODBC and Access with Northwind database
> <http://xmlproj.dyndns.org/faqomatic/cache/17.html>
>
> The archives for this list surely contain some more detailed recipes for
> creating the DSN.
>
> --
> Bart.
