Hi Dan, This seems to be a common issue with oracle on windows + activestate perl - I did a google search on your error message:
http://www.perlmonks.org/?node_id=707010 http://community.activestate.com/forum-topic/problem-dbd-oracle-install http://aspn.activestate.com/ASPN/Mail/Message/activeperl/2475583 I am no an oracle expert, but perhaps you need to make sure ORACLE_HOME, and other environment variables are set appropriately for the user running your apache2 service? Cheers, David On Fri, Sep 12, 2008 at 8:38 PM, Dan He <[EMAIL PROTECTED]> wrote: > Hi, All > I just setup the environment for codestriker(codestriker1.96 + activeperl > 5.8.8 + apache2.2) > > > http://localhost/codestriker/codestriker.pl --> errors like this: > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Software error: > > install_driver(Oracle) failed: Can't load > 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: > load_file:The specified module could not be found at > C:/Perl/lib/DynaLoader.pm line 229. > at (eval 39) line 3 > Compilation failed in require at (eval 39) line 3. > Perhaps a required shared library or dll isn't installed where expected > at C:/codestriker-1.9.6/lib/Codestriker/DB/Database.pm line 61 > > For help, please send mail to the webmaster ([EMAIL PROTECTED]), > giving this error message and the time and date of the error. > > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > I'm sure this file('C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' ) does > exist in the directory. > > could anybody help with this issue? Thank you very much. > > > > > > BTW, I did another test, just test Oracle connection in a perl file: > testOracle.pl. and then run it in commond line: perl testOracle.pl. > > it works well. > > +++++++++++++++++++++++++++++++++++ > > use DBI; > my $dbh = DBI->connect( "dbi:Oracle:orcl", "test", "test" ) > or die "Can't connect to Oracle database: $DBI::errstr\n"; > my $sql = qq{ SELECT firstname, lastname FROM staff where id<300 }; > my $sth = $dbh->prepare($sql); > $sth->execute(); > > my($tname, $tabtype); > > $sth->bind_columns(undef, \$tname, \$tabtype); > > print "List of tables:\n\n"; > while( $sth->fetch() ) { > print "firstname: $tname, lastname: $tabtype\n"; > } > $sth->finish(); > $dbh->disconnect or warn "DB1 disconnection failed: $DBI::errstr\n"; > > +++++++++++++++++++++++++++++++++++ > > > > > > · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · > · > Thank you! > > Dan HE > Associate Software Process Engineer > > Thomson Reuters > > O 86-10-62674960 > > [EMAIL PROTECTED] > > thomsonreuters.com > > This email was sent to you by Thomson Reuters, the global news and > information company. > Any views expressed in this message are those of the individual sender, > except where the sender specifically states them to be the views of Thomson > Reuters. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Codestriker-user mailing list Codestriker-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/codestriker-user
