I am running a ActivePerl 5.6.1 on a Windows 2000 Server. I have installed DBI and DBD-Oracle. My script when ran through a command line at a dos prompt it connects to an Oracle database successfully and returns all the correct values, but as soon as I run it through a browser I get this error:
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 206.
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
This is the beginning of my script:
use lib 'http://myIP_address/Scripts';
use lib 'D:\Perl\site\lib\auto\DBD\Oracle';
I have been to many other groups but none of them were able to help me. I hope I can find my answer here.
It seems to me yr installation of DBD/DBI failed.
Check your readme files carefully and reďnstall it.
I had a lot of problems installing DBD/DBI for informix. It always gave problems on the 'use DBI'
I reinstalled it, carefully respecting everything they said in the README's and now it works.