Re: DBD::Oracle/Windows2000 OK from prompt, not mod_perl?

2002-10-31 Thread Larry Leszczynski

   I'm having a problem on Windows 2000 where DBD::Oracle works fine from
   perl on the command prompt but not from inside mod_perl.  I think it is a
   problem loading DLLs but I can't figure out what's different running under
   mod_perl.

I started making progress after taking Randy's suggestion and copying the
DLLs into my Apache directory just to see what happened.  The Oracle
client was originally installed on a mapped network drive, once I moved it
to my local drive and pointed ORACLE_HOME to that location it worked fine.
Not sure why Apache would have trouble finding DLLs on a network drive but
not on a local drive, but it works now so I'm happy.  Thanks for the help
guys!

Larry





Re: DBD::Oracle/Windows2000 OK from prompt, not mod_perl?

2002-10-30 Thread Perrin Harkins
Larry Leszczynski wrote:


I'm having a problem on Windows 2000 where DBD::Oracle works fine from
perl on the command prompt but not from inside mod_perl.  I think it is a
problem loading DLLs but I can't figure out what's different running under
mod_perl.  The machine is running:
  ActiveState perl 5.6.1 build 633
  Apache 1.3.26 (prebuilt)
  mod_perl 1.27_01-dev (Randy Kobe's build)
  DBD-Oracle8 (ActiveState ppm)



You can't just mix and match like that.  Modules that you want to use 
under mod_perl have to be built against the same perl that mod_perl was 
built with.  If there is a DBD::Oracle with Randy's distro, use it. 
Otherwise, you need to build DBD::Oracle with the same perl he used, or 
build mod_perl with ActiveState 633.

- Perrin



Re: DBD::Oracle/Windows2000 OK from prompt, not mod_perl?

2002-10-30 Thread Larry Leszczynski
Hi Perrin -

 I'm having a problem on Windows 2000 where DBD::Oracle works fine from
 perl on the command prompt but not from inside mod_perl.  I think it is a
 problem loading DLLs but I can't figure out what's different running under
 mod_perl.  The machine is running:
ActiveState perl 5.6.1 build 633
Apache 1.3.26 (prebuilt)
mod_perl 1.27_01-dev (Randy Kobe's build)
DBD-Oracle8 (ActiveState ppm)
 
 
 You can't just mix and match like that.  Modules that you want to use 
 under mod_perl have to be built against the same perl that mod_perl was 
 built with.  If there is a DBD::Oracle with Randy's distro, use it. 
  Otherwise, you need to build DBD::Oracle with the same perl he used, or 
 build mod_perl with ActiveState 633.

Hmmm, I was hoping that was not the case - all my other mod_perl stuff
works fine, including libapreq stuff and SOAP::Lite, but maybe just by
coincidence...

Hey Randy, do you happen to have a DBD-Oracle build?

(Btw, Randy deserves major kudos for maintaining his stuff at
theory5x.winnipeg.ca!)


Thanks,
Larry Leszczynski
[EMAIL PROTECTED]