Re: Questions related to DBI and DBD::Oracle

I appreciate your quick reply.

Thanks,
Shikha Pandit
WHS IT - Clinical Solutions
Phone: (847) 964-8709

WHS -> Walgreens Health Services



John Scoles <scoles@xxxxxxxxxxx>
07/30/2008 07:25 AM
Please respond to
scoles@xxxxxxxxxxx


To
Shikha.Pandit@xxxxxxxxxxxxx
cc
dbi-users@xxxxxxxx, Yuan.Zhang@xxxxxxxxxxxxx, Katherine.Yu@xxxxxxxxxxxxx
Subject
Re: Questions related to DBI and DBD::Oracle






You will have to do all three

You will need

DBI
DBD::Oracle
Oracle client
and most likely some environment variables as well

First actually read the readme files
http://search.cpan.org/src/PYTHIAN/DBD-Oracle-1.21/README it has
detailed instructions on how to set up DBD::Oracle

You can use the Oracle Instant client for free and you can get it here

http://www.oracle.com/technology/tech/oci/instantclient/index.html

cheers
John Scoels


Shikha.Pandit@xxxxxxxxxxxxx wrote:

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


<http://search.cpan.org/%7Epythian/DBD-Oracle-1.21/Oracle.pm>

Relevant Pages

  • Splitting an Office 2007 install
    ... I have Office 2007 installed on my main workstation. ... I also have a WHS ... an add-in for WHS that provides an Outlook interface in the WHS console. ... Once the add-in is released for general use, I would like to install my ...
    (microsoft.public.office.setup)
  • Re: Porting Offfice 2003 to Vista
    ... If yours is a retail version, the EULA permits having it ... I have an OEM version of Office 2003 and the EULA quite clearly states that I may install it on a desktop and a laptop. ... "whs" wrote: ...
    (microsoft.public.windows.vista.general)
  • Re: MediaCenter 2k5 as Home Server?
    ... Windows Home Server and Windows Media Center are two distinct operating ... MCE can install the WHS Connector and use the features available ...
    (microsoft.public.windows.mediacenter)
  • Re: formatting partition in vista
    ... If you install e.g. Windows7, no prior formatting is required. ... partition will be formatted during the installation. ...
    (microsoft.public.windows.vista.installation_setup)
  • RE: DBI problem
    ... I had Oracle 8 all along, I upgraded to ActiveState Perl 5.8.7 from ... DBD 1.16 and DBI 1.48. ... Did you install DBD::Oracle? ...
    (perl.dbi.users)