DBD/DBI issue

HI All,

I am trying to connect to the oracle db in the perl file and getting the follwing issue. I am using the DBI module but the error is reffereing the DBD module. Any pointers?

Thanks!



#!C:\iw-home/iw-perl/bin/iwperl.exe
use DBI;
$ENV{ORA_HOME} = "C:\oracle\bin";
my $db = DBI->connect("DBIracle:nnnnn", "yyyyy", "nnnnn");
$db->disconnect;

Output:

C:\Documents and Settings\jhenken>iwperl C:\iw-home\local\bin\test
\db.ipl
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains
: C:/iw-home/iw-perl/lib C:/iw-home/iw-perl/site/lib C:\iw-home\iw-perl\vendor\lib .) at (eval 1) line 3.
Perhaps the DBD: Smiley Surprised

racle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: ExampleP, ODBC, Proxy, Sponge.

Find more posts tagged with

Comments

nipper

Reading another thread, it appears that only part of DBD is installed, and not the Oracle.pm (I checked on my 6.7.1 SP1 system). There have been a few threads about installing the Oracle PM through cpan. Search the threads, but it is not easy. I have not done it (though I fought through the excel pm install a couple years ago).

Adam Stoller

You have to build DBD: Smiley Surprised

racle on your server - it hasn't been shipped with TeamSite since 5.x (which was using Perl 5.00503)

Also - in your code - put the ENV settings within a BEGIN { ... }; block - otherwise the environment setting is too late.