Hi,
You will need the oracle client. Without the oracle client, you will not
have the oracle drivers and libraries that the oracle.pm will need.
Regards,
Michael
On Wed, 30 Jul 2008
[EMAIL PROTECTED] wrote:
Date: Wed, 30 Jul 2008 06:59:52 -0500
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [email protected], [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Questions related to DBI and DBD::Oracle
Thanks for the input.
I have one more question. If I install oracle.pm will that solve my
problem or do I need to install oracle client on the unix box to make it
work.
Do I need to setup any other environment variables.
Looking forward for the answers.
Thanks,
Shikha Pandit
WHS IT - Clinical Solutions
Phone: (847) 964-8709
WHS -> Walgreens Health Services
[EMAIL PROTECTED]
07/29/2008 07:53 PM
To
[EMAIL PROTECTED]
cc
[email protected], [EMAIL PROTECTED]
Subject
Re: Questions related to DBI and DBD::Oracle
You will have to install the DBD::Oracle perl module befoer you can use
it.
http://search.cpan.org/~pythian/DBD-Oracle-1.21/Oracle.pm
so far you only have DBI or th Data Base Interface you need a Data Base
Driver to make it actually connect ot a DB. This is why it is asking for
DBD::Oracle
Hello,
I am trying to connect to the oracle database through a perl script. I
have installed DBI module on my server.
I need to run my script on an App server and the database is on the
other
server.
When I am running the test script which is
use DBI;
$dbh = DBI->connect( 'dbi:Oracle:dwhs01',
'username',
'password',
) || die "Database connection not made:
$DBI::errstr";
print "Connected to Database";
It gives me this error.
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC
contains: /usr/opt/perl5/lib/5.8.2/aix-thread-multi
/usr/opt/perl5/lib/5.8.2
/usr/opt/perl5/lib/site_perl/5.8.2/aix-thread-multi
/usr/opt/perl5/lib/site_perl/5.8.2 /usr/opt/perl5/lib/site_perl .) at
(eval 3) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
at test.pl line 9
Please advice what all do I need to setup and install.
Looking forward for the reply.
Any inputs will be appeciated.
Thanks,
Shikha Pandit
WHS IT - Clinical Solutions
Phone: (847) 964-8709
WHS -> Walgreens Health Services
--
---//---
Time flies like the wind. Fruit flies like bananas.
--- Groucho Marx
Either write something worth reading or do something worth writing.
--- Benjamin Franklin
