Questions related to DBI and 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: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Sharepoint not working anymore
    ... a way to rebuild the master database (which you can think of as the database ... Microsoft Small Business Server Support ... SBS Newsgroups: ... >> You mentioned that you had set out to install SP1... ...
    (microsoft.public.windows.server.sbs)
  • Re: db repair
    ... Server. ... VB Script looks amazingly like VBA, since they're both based upon the same ... See http://www.mvps.org/access/general/gen0041.htm for the VBA code to ... this won't compact the database ...
    (microsoft.public.access.setupconfig)
  • Re: Multiple instances
    ... "We wrote the books on Project Server" ... >> install; one production, one demo. ... >> I first created a new project database, populated it by running setupdb, ... >> had MSProjectServerUser in the MSProjectMember Role text box under ...
    (microsoft.public.project.pro_and_server)
  • RE: SPS WSS SQL 2000 same machine
    ... that the MSSQL$SHAREPOINT SQL Service instance is not running. ... both are installed on the SQL Server Default instance. ... You MUST install WSS before SPS. ... However, when selecting the Database ...
    (microsoft.public.sharepoint.portalserver)

Quantcast