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]

Reply via email to