No, sorry. That was a recommendation from someone else to install the
latest, so I was just telling how to install Oracle8, but in your case your
driver should do.
Have you tried the permissions change as I mentioned in the previous
message. Try to log on as admin if you haven't already. Or try to
resintall everything under the same user name.
Ilya Sterin
-----Original Message-----
From: Anthony Bouvier [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 01, 2001 11:22 PM
To: Sterin, Ilya; David M. Davisson
Cc: [EMAIL PROTECTED]
Subject: RE: Win32 DBI Connectivity to Oracle
Install DBD-Oracle8? Even though I am attempting to connect to an
Oracle 7.3 database?
--
anthony bouvier
notsoevil philosopher
--
> -----Original Message-----
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 01, 2001 11:18 PM
> To: Anthony Bouvier; David M. Davisson
> Cc: [EMAIL PROTECTED]
> Subject: RE: Win32 DBI Connectivity to Oracle
>
>
> ppm install DBD-Oracle8
>
> -----Original Message-----
> From: Anthony Bouvier [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 30, 2001 4:27 PM
> To: David M. Davisson
> Cc: Sterin, Ilya; [EMAIL PROTECTED]
> Subject: Re: Win32 DBI Connectivity to Oracle
>
>
> 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
>
