Do you have the Oracle client installed on the machine where you are
connecting from?
Also look at your connect statement, since after you resolve you problem it
will probably fail on the connect anyways. Run perldoc DBD::Oracle and see
the connection parameters. You must also include SID.
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
