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]