Re: [Codestriker-user] Codestriker links to Oracle failed :install_driver(Oracle) failed

[David S. <dav...@gm...>]

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 <da...@th...> 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 (da...@th...),
> 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
>
> da...@th...
>
> 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.