Just a question after installing DBI did you install DBD::Oracle??
If not
>ppm install DBD::Oracle
Sorry if you already did.
Also look from the error message that some access is denied. Are you
running as an admin who installed the ORacle client? If not you must either
change permissions or run as the user who has permissions.
Looks like some permissions are screwing things up.
Ilya Sterin
-----Original Message-----
From: Anthony Bouvier
To: [EMAIL PROTECTED]
Sent: 3/30/01 11:25 AM
Subject: Win32 DBI Connectivity to Oracle
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