RE: Oracle question
- From: stbaldwin@xxxxxxxxxxxxxxxx (Steve Baldwin)
- Date: Wed, 28 Jun 2006 08:58:18 +1000
Alternatively you can install DBD::Oracle on the DB server (which will
presumably have all the relevant Oracle bits) and install and use DBD::Proxy
on your client machine.
Even if you use ODBC, you still need the Oracle client underneath it.
Cheers,
Steve
-----Original Message-----
From: Andy Hassall [mailto:andy@xxxxxxxxxxx]
Sent: Wednesday, 28 June 2006 8:46 AM
To: kevin@xxxxxxxxxxxxxxxxxxx; dbi-users@xxxxxxxx
Subject: RE: Oracle question
Installing an Oracle client and compiling DBD::Oracle against that is
probably your best bet, particularly on Linux.
Oracle have a package called Instant Client which is the libraries in a
zip
file; much lighter than the full client install. It's available on
otn.oracle.com. You'll need the "Basic" and "SDK" packages, and preferably
the "SQL*Plus* package too.
More info in the DBD::Oracle README file and manual page.
--
Andy Hassall :: andy@xxxxxxxxxxx :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
________________________________
From: LLC [mailto:kevin@xxxxxxxxxxxxxxxxxxx]
Sent: 27 June 2006 23:34
To: dbi-users@xxxxxxxx
Subject: DBD:Oracle question
Hi List;
I have needs to write a perl DBI script on a Linux host which will pull
data
from an instance of Oracle on a second Linux host.
Can I grab an Oracle ODBC Driver and reference the driver in my
DBI_>Connect
call or do I have to download and install the Oracle client?
If ODBC works, any tips on where to get an Oracle ODBC driver for linux ?
Finally, In either case what should my connect string look like? Here's
what
I have so far, is this correct?
# for a box with Oracle client installed for acess to an oracle database
named testdb on hostname myhost.mydomain.com:
my $dbh = DBI->connect("dbi:Oracle:myhost.mydomain.com:testdb",
'username',
'passwd' );
# for a box with a local Oracle ODBC driver & connection (via .odbc.ini)
with the DNS entry name of ORADB1
my $dbh = DBI->connect("dbi:Oracle:server=ORADB1", 'username', 'passwd'
);
Thanks in advance for your help
.
- References:
- RE: Oracle question
- From: Andy Hassall
- RE: Oracle question
- Prev by Date: RE: Oracle question
- Next by Date: Re: Connecting from Linux onto MS-SQL-Server
- Previous by thread: RE: Oracle question
- Next by thread: DBD:CSV problem on Solaris
- Index(es):
Relevant Pages
|
|
