Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re^2: Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8...

by willjones (Sexton)
on Aug 26, 2008 at 23:54 UTC ( #707026=note: print w/replies, xml ) Need Help??


in reply to Re: Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8...
in thread Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8...

Yeah, it's installed. I opened up PPM and typed DBD-Oracle in the search box. It came up and was showing as installed. I marked it for uninstall and ran the action. Then I marked it for install again after this and re-installed it. It is getting the pre-compiled module for Windows from the ActiveState site... http://ppm4.activestate.com/MSWin32-x86/5.8/822/package.xml

The version number I have installed is DBD-Oracle 1.19.
I went to C:\Perl\site\lib\auto\DBD\Oracle and saw 10 files listed there one of which was Oracle.dll which is the file the error message complains about.
I suppose I could try to get DBD::ODBC working although I'd like to use DBD-Oracle if it's at all possible.
Thanks...
  • Comment on Re^2: Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8...

Replies are listed 'Best First'.
Re^3: Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8...
by syphilis (Bishop) on Aug 27, 2008 at 00:21 UTC
    one of which was Oracle.dll which is the file the error message complains about

    That's probably not the file that's causing the grief. I think the error message is telling you that dll can't be loaded because another dll can't be found.

    Without knowing anything about Oracle itself, I would expect that it ships with its own dll(s), and your problem could be that the Oracle dll(s) can't be found. Make sure the location of the Oracle dll(s) is in your path.

    Cheers,
    Rob
      Without knowing anything about Oracle itself, I would expect that it ships with its own dll(s), and your problem could be that the Oracle dll(s) can't be found. Make sure the location of the Oracle dll(s) is in your path.

      The "Event Viewer" would have a more detailed error message saying which dll

Re^3: Having trouble trying to use DBD::Oracle with ActivePerl 5.8.8...
by mr_mischief (Monsignor) on Aug 27, 2008 at 00:16 UTC
    In general, if there's a package from ActiveState for it, then it should just work. I've never used DBD::Oracle myself so I couldn't say if there's anything special in the way of configuration.

    This dbi-announce message leads me to believe the page you mentioned earlier about the module needing 5.6.1 or earlier is outdated or incorrect. The message is a recount of a successful test with 5.8.7 by someone who develops the module.

    I do know that ActiveState has a support site. This page states that PPM versions no longer exist due to licensing issues, but that page is copyright 2004 so things may have changed yet again by now. Indeed, this PPM info page from 2006 says there is now a DBD::Oracle based around the Oracle Instant Client Library available for ActiveState Perl on Windows. Both of those pages suggest DBD::ODBC might be the way to go. This 2008 support exchange states that the only way to get DBD::Oracle to work for ActiveState Perl 5.8 and 5.10 is to build from CPAN source because ActiveState doesn't have the InstantClient version done yet. This one says that 5.10.0.1003 has DBD::Oracle included.

    I've read good things just now about DBD::Oracle 1.19 from the trouchelle.com PPM repository. It seems some people have better luck using that PPM than the one from ActiveState.

    YMMV, of course. I'm not a user of the module.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://707026]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (5)
As of 2020-04-06 19:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    The most amusing oxymoron is:
















    Results (41 votes). Check out past polls.

    Notices?