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

  • 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)
  • RE: oracle win2k ORA-1222 problems
    ... AS does not provide a package, but you can and should install both DBI and DBD::Oracle from ftp.esoftmatic.com. ... Oracle is listed as "failed" if I recall correctly. ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)
  • RE: Accessing oracle from windows 2000
    ... You need oracle net8 anyway for odbc so it is likely you will ... just be able to install the activestate DBD::Oracle and DBI. ... > documentation on DBI and I can't find the answers I'm looking for. ...
    (perl.dbi.users)
  • Re: Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... The project I'm trying to get running, consists of approx 25 seperate packages where 3-4 of them gets data from different Oracle sources, but I'm not even got to the point where I'm trying to run the whole lot. ... There are two issues in the topic that could be an issue, and that is to switch the whole project to 32-bit mode and then the part that says that the Designer only shows 32-bit versions of the provider. ... What I think I'll try now, it to install the 32-bit version of the Oracle ODAC to see if that makes any difference. ... uninstall ODAC and when I uninstall the regular Oracle Client with the ...
    (microsoft.public.sqlserver.dts)
  • RE: Accessing oracle from windows 2000
    ... I edited the ppd file to use the correct path. ... Bjorn, I already have DBI installed, so I downloaded DBD-Oracle8.zip ... from active state, unpacked it, and tried 'ppm install ... I didn't need any oracle libraries. ...
    (perl.dbi.users)