Anthony,
Which DBD::Oracle package did you install and which version of Oracle are
you connecting to? There are two Win32 packages for Oracle, DBD-Oracle and
DBD-Oracle8. I had a similar problem when I installed DBD-Oracle instead of
DBD-Oracle8.
--
Dave Davisson
[EMAIL PROTECTED]
----- Original Message -----
From: "Anthony Bouvier" <[EMAIL PROTECTED]>
To: "Sterin, Ilya" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 11:58 AM
Subject: Re: Win32 DBI Connectivity to Oracle
> 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
