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


.

Relevant Pages

  • Re: Is mysql.pm part of DBI?
    ... Think of DBI as the global module to connect to various databases. ... This DBD-module works as layer between the DBI and the database. ... install DBD::mysql ...
    (comp.lang.perl.misc)
  • Re: Questions related to DBI and DBD::Oracle
    ... If I install oracle.pm will that solve my ... so far you only have DBI or th Data Base Interface you need a Data Base ... I am trying to connect to the oracle database through a perl script. ...
    (perl.dbi.users)
  • Re: Help!
    ... > want to install the DBI module so I can star talking with my databases, ... install DBI ... then need to install a driver for our database as DBI is the abstraction ... each driver will come with a README file explaining how to install it. ...
    (perl.dbi.users)
  • connect: Cannot assign requested address using DBD::Sybase
    ... I am trying to connect to a database using DBD::Sybase and I am getting ... use DBI; ... although according to him this perl module ... doesn't use bind(). ...
    (SunManagers)
  • Re: Help!
    ... >> want to install the DBI module so I can star talking with my databases, ... > install DBI ... > then need to install a driver for our database as DBI is the abstraction ... > each driver will come with a README file explaining how to install it. ...
    (perl.dbi.users)