no recent perl on any platform seems to like it.
You're reading too much into automated testing.
DBD-Oracle, like many distributions, requires a live monkey to read the README and push some buttons :)
| [reply] |
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...
| [reply] |
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
| [reply] |
| [reply] |
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.
| [reply] |