Yes, the Oracle Client (and all SQL*Net software) is installed. SQLPlus can
connect just fine, as can any ColdFusion (cfm) application using ODBC.
Ah, I knew SID had to be included, sorry for leaving it off. But as you can see
the execution is not even getting that far because the connection is never
initiated to pass along the username and password. The module itself is failing
to load for some odd reason. I can just feel this is something extremely small
that I am just overlooking, but I just haven't been able to pin it down.
"Sterin, Ilya" wrote:
>
> 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
