c:>ppm install DBD::Oracle
It pulled the most recent version (I assume) from ActiveState ppm archive. I am
connecting (or more precisely attempting to connect to) Oracle 7.3 (which is on
a Unix system). The webserver is IIS on NT.
"David M. Davisson" wrote:
>
> 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
