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: Garrett Ellis [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 5:20 PM
To: [EMAIL PROTECTED]
Subject: RE: Using Linux and Perl to Access Oracle on NT
I received a number of replies privately and publicly, and my thanks and
appreciation to all who took the time to respond.
By installing the Oracle 8i Linux client with the "Programmer" option
selected, I was able to acquire all of the necessary libraries for compiling
DBD::Oracle. After installation, minor changed needed to be made to
TNSNAMES.ORA, mostly due to my ignorance of Oracle's resolution process, but
now it works perfectly.
In response to the concern re: Debian being an unsupported distribution, of
that I was aware. The only necessary tweaking which resulted from my
configuration was the need to install X11, which allowed me to use the
not-quite-Universal Installer, which provided access to everything else I
needed. Also, since I am not using Oracle Names for host resolution nor is
local DNS available, I updated /etc/hosts so that the WinNT machine could be
resolved properly.
Thanks again, everybody! Collaboration such as this is a very helpful
resource.
Cheers,
Garrett Ellis
-----Original Message-----
From: Stephen Clouse [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 4:09 PM
To: Garrett Ellis
Cc: [EMAIL PROTECTED]
Subject: Re: Using Linux and Perl to Access Oracle on NT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, Jun 21, 2002 at 02:49:18PM -0700, Garrett Ellis wrote:
> My big question is, am I pursuing the proper course of action if I am to
use
> Perl from Linux to access Oracle on NT? Or is there something else I could
> do to accomplish this?
No, you need the native Linux binaries. Download the server package from
Technet or order a CD pack from Oracle if you have a slow connection (the
download is roughly 1GB). Then install the client and OCI components. That
should be everything you need to build DBD::Oracle.
Also be warned -- Debian is not officially supported by Oracle, so some
tweaking
may be necessary to get things completely working.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE9E7IGA4aoazQ9p2cRAs4sAJ46YT1Asx+CZnPhgBY/BuJf6b0DRwCg7xHk
TJjCyDLCYoBD3H5wR1SS+Yk=
=OTvv
-----END PGP SIGNATURE-----
