Re: Questions related to DBI and DBD::Oracle

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 Shikha.Pandit@xxxxxxxxxxxxx wrote:

Date: Wed, 30 Jul 2008 06:59:52 -0500
From: Shikha.Pandit@xxxxxxxxxxxxx
To: scoles@xxxxxxxxxxx
Cc: dbi-users@xxxxxxxx, Yuan.Zhang@xxxxxxxxxxxxx, Katherine.Yu@xxxxxxxxxxxxx
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



scoles@xxxxxxxxxxx
07/29/2008 07:53 PM

To
Shikha.Pandit@xxxxxxxxxxxxx
cc
dbi-users@xxxxxxxx, yuan.zhang@xxxxxxxxxxxxx
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
.

Relevant Pages

  • RE: ADO and Oracle Serwer problem
    ... > I've started using ADO technology ana Visual C++ compilator. ... > Provider for ADO to Access to Database. ... > read documentation for OleDBC I find out, that I must install Oracle Client ...
    (microsoft.public.data.ado)
  • Re: in query expression MSysAccounts.name. ERROR
    ... "You might want to go ahead and try re-registering your DAO360.dll file. ... To register this file, ... > the Oracle install. ... I have not re-installed the Oracle Client. ...
    (microsoft.public.access.security)
  • Re: perl Oracle
    ... > You will need to install the Oracle client on the server you wish to ... > the oracle server? ... If you are not the intended recipient, ...
    (perl.dbi.users)
  • Re: Connection to ORACLE: Need some explanations
    ... The Oracle client is installed because it has been installed on purpose ... ¤ ... Oracle OLEDB Provider is a separate install and it is the one to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error while executing DBI module
    ... current Oracle client or DBD:Oracle did now install correctly or is not ... Can you tell us what version of DBI, DBD:Oracle, Oracle Client and Oracle ... I get the following errors while executing the DBI module of perl. ... shared object file: No such file or directory at ...
    (perl.dbi.users)