SERVICES On Fri, 21 Jul 2006, Chris Rovers wrote:
[...]
>  I've installed DBI and DBD::Oracle, using ppm.
[...]
>  The output I get from this script when run through PerlEx is :
> 
>  Failed to connect to Database : install_driver(Oracle) failed: Can't
>  load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module
>  DBD::Oracle: load_file:Access is denied at
>  C:/Perl/lib/DynaLoader.pm line 230. at (eval 7) line 3 Compilation
>    failed in require at (eval 7) line 3. Perhaps a required shared
>    library or dll isn't installed where expected at c:\intracgi\hris-
>    chris\testconnect.plex line 9 All done
> 
> 
>  When I run it standalone (from the dos prompt), I get :
> 
>  Content-type: text/html
> 
>  Failed to connect to Database : DBI
>  connect('dvhris.world','dvhris',...) failed: ORA-12705: Cannot access
>  NLS data files or invalid environment specified (DBD E RROR:
>  OCISessionBegin) at c:\intracgi\hris-chris\testconnect.plex line 9 All
>  done

I suspect that you don't have c:\Perl\bin on your *system* PATH, or if
you do, then that you haven't rebooted since doing this.

The DBD-Oracle module from our PPM repository put additional libraries
from the Oracle Instant Client into the Perl\bin directory.

This doesn't really explain why it fails from the commandline though.
Are you sure you successfully completed the post-install script that
the PPM package executes?  It requires you accept the Oracle license and
then downloads and copies 3 DLLs into C:\Perl\bin.

Cheers,
-Jan



_______________________________________________
PerlEx mailing list
PerlEx@[...].com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs