I get the following running under IIS as a CGI (perl.exe). Other modules work fine, but not DBI/Oracle - I do not have any other sources to test other DBI drivers:

Create Connection to PROD.
Content-type: text/html

Software error:

install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/O
+racle/Oracle.dll' for module DBD::Oracle: load_file:The specified mod
+ule could not be found at C:/Perl/lib/DynaLoader.pm line 206.
 at (eval 9) line 3
Compilation failed in require at (eval 9) line 3.
Perhaps a required shared library or dll isn't installed where expecte
+d
 at C:\pubora\test.pl line 17
[download]

with the following code:

use strict;
$ENV{'ORACLE_HOME'} = 'C:/oracle/ora81';
use CGI qw(:all);
use CGI::Carp qw(fatalsToBrowser);
use DBI;

print header,
start_html('Simple Example Using DBI/DBD::Oracle and CGI'),
h1('Create Connection to PROD.');

my @drivers = DBI->available_drivers();
die "No Drivers Found\n" unless @drivers;

my $dbh = DBI->connect( "dbi:Oracle:prod","system","manager", {RaiseEr
+ror => 1, PrintError => 1 }) 
   or die "Can't connect to Prod: $DBI::errstr\n";
   
my $sth = $dbh->prepare("select count(*) from tab");
$sth->execute or die "Cannot execute the select statement\n";
my @row;
while (@row = $sth->fetchrow_array() ) {  print "ROW: @row\n";  }
warn "Data Fetching error with $DBI::errstr\n" if $DBI::err;
$dbh->disconnect or warn "Disconnect failed\n";
print end_html;
exit;
[download]

I have checked file permissions and the existence of the file Oracle.dll in the location spec'd. This file works fine as a 'guest' at the command line. Also, there is only one Perl installed. Where else can I look? Thanks!

Edit by tye to change PRE tags to CODE tags