My simple script:
#######
use DBI;
use strict;
my $dbh = DBI->connect("dbi:Oracle:host=myhost", 'foo', 'bar') or die "Cannot connect
to server: $DBI::errstr\n";
print "Content-type: text/html\n\n";
print "Hey, I got this far!<p>";
######
When hit via web server (IIS on NT) the following error message is displayed:
install_driver(Oracle) failed: Can't load
'D:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:
load_file:Access is denied at D:/Perl/lib/DynaLoader.pm line 200.
at (eval 1) line 3 Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected at
d:\currmktg\test.cgi line 20
And when called from the command prompt:
Content-type: text/html
Hey, I got this far!<p>
Also, there was a DNS already set up on the target NT box to connect (via ColdFusion)
and connection via SQL*Plus is totally possible.
I also had DBD::ODBC installed to see if I connect via that method; it returns:
DBI->connect(LWCWeb) failed: Specified driver could not be loaded due to system error
5 (Oracle73 Ver 2.5).
At the command prompt, 'net helpmsg 5' returns the following definition: 'Access
Denied'. So the error messages seem to be idenitical
for two different methods of connection.
Any suggestion as to the possible problem? Please, please advise.
((Most recent (stable) ActiveState Perl and most recent DBDs installed via PPM.))
--
Anthony Bouvier
