Here is the skinny...
I'm running...
-IIS Nt 4.0 server
-Activestate perl 5.6.1 with DBD:Oracle installed
-Connecting to Oracle 8.0 remote database
-Installed Oracle client on my server and Sql*Plus connects fine.
Situation...
-Perl connects fine from command prompt and returns records.
-I'm trying to run this code from my webserver cgi-bin...
#!d:\perl\bin\perl
use DBI;
use CGI;
$cgi = new CGI;
$title = "My Oracle Test";
my $dbh2 =
DBI->connect("dbi:Oracle:host=123.456.789.123;sid=ORCL","userr","passwordt",{
RaiseError => 1 });
$sth2 = $dbh2->prepare (qq{SELECT LOCATION, media_id from media where media_id =
'06'});
$sth2->execute();
print $cgi->header ();
print $cgi->start_html (-title => $title, -BGCOLOR=>'#CCCCCC');
while (($location, $media_id) = $sth2->fetchrow_array ())
{
print "<TR><TD>\n";
print "<TD BGCOLOR=#FFFFFF>$location</TD>\n";
print "<TD BGCOLOR=#FFFFFF>$media_id</TD></TR>\n";
}
print "</TABLE>";
$dbh2->disconnect();
exit;
-My server returns this error....
CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP
headers. The headers it did return are:
install_driver(Oracle) failed: Can't load
'D:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The
specified module could not be found at D:/Perl/lib/DynaLoader.pm line 206.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at D:\Inetpub\myroot\host.mydomain.com\htdocs\cgi-bin\new.pl line 6
*The DBD:Oracle package was installed prior to the Oracle client software. Does that
matter?
The Dynaloader.pm module says that line 206 is where generic errors are reported from
DBI. It looks like my registry settings are okay, as well as the directory structure
for my d:\orant and d:\perl\site\auto directories.
I think I'm missing something very simple but can't find it. Any help will be
appreciated.
Thanks,
Jeff Bell
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
