468,103 Members | 1,311 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,103 developers. It's quick & easy.

strange problem connecting oracle db

when i run perl script in the cmd prompt , it runs well and outputs results from db.
but when i run the same script on apache server internet explorer. i get an error as
install_driver(Oracle) failed: Can't load 'C:/perl/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified module could not be found at C:/perl/lib/DynaLoader.pm line 202.
at (eval 5) line 3
Compilation failed in require at (eval 5) line 3.
Perhaps a required shared library or dll isn't installed where expected
at D:/Profiles/CHJT87/My Documents/My Website/cgi/trials/connection.pl line 8
isnt this strange ??? i dont understand , is it error of oracle or perl apache server??

if anyone have knowledge about this do let me know,
thanks for reading the mail.
Aug 3 '09 #1
17 5592
4,059 Expert 2GB
It looks to me like the Oracle drivers perl needs were not installed properly. How did you install DBD::Oracle? Are you using activeperl or strawberryperl or something different? With activeperl you should first try using the PPM application that comes with it to install modules. If strawberry perl you can install it from the CPAN shell.
Aug 3 '09 #2
thanks kevin,
i just installed activeperl and i looked in perl/lib DBD was already there
but still i tried to download it from cpan and just copy pasted folder in lib. how to use ppm application.i am new to perl.
Aug 3 '09 #3
4,059 Expert 2GB
open the activeperl folder on your hard drive and click on documentation and read the instructions for PPM. You can also read them on the activestate website. You can't copy and past the driver code into the DBD folder, it needs to be installed.
Aug 4 '09 #4
i just have perl folder and i tried doing
ppm install DBD-ORACLE. but it showed that package doesnt exits

this is the error
C:\>ppm install DBD-Oracle;
Downloading ActiveState Package Repository packlist...failed 500 Can't connect t
o ppm4.activestate.com:80 (Bad hostname 'ppm4.activestate.com')
ppm install failed: Can't find any package that provides DBD-Oracle;

on previous computer i setup , it s working well. ther i had activeperl folder then perl folder in that
here i just have perl folder..
Aug 4 '09 #5
4,059 Expert 2GB
add more repositories to the PPM application. See the PPM documentation.

Here is three good repositories:

Aug 4 '09 #6
4,059 Expert 2GB
If there is no activestate or activeperl folder and you are using activeperl, I don't know what to tell you. I have used activeperl for years and there was always a folder on the hard drive.
Aug 4 '09 #7
i download this and installed it

so on my computer it create a folder for perl this way
Aug 4 '09 #8
when i try to add the repositories u gave from ppm it shows me fail .:-(
Aug 4 '09 #9
if u say i get a activeperl folder then can u please give me the link from you installled ? so that i can get a similar configuration.
thank you so much,
Aug 4 '09 #10
4,059 Expert 2GB
There should be an activestate or activeperl folder where all of the activestate/perl documentation is stored. If for some reason there isn't, you can read all the documentation online at the activestate website. Here is a link to the PPM instructions for activeperl 5.10

Aug 4 '09 #11
4,059 Expert 2GB
I don't use activeperl anymore, I switched to strawberry perl when I got my new computer.

If you are using Windows click on the start button, then programs, then search for the activestate or activeperl folder, should be on the C drive but could be on other drives if you installed to a different drive.
Aug 4 '09 #12
when i add this to the repository

it gives me error
downloading file failed 500 cannot connect to www.bribes.org:80
(Bad hostname :www.bribes.org)
Aug 4 '09 #13
4,059 Expert 2GB
That could be a firewall or proxy server problem. Read the "PPM, Proxies and Firewalls" section of the PPM documentation.


If that is not the problem, I don't know.
Aug 4 '09 #14
3,503 Expert Mod 2GB
It would have to be some kind of firewall problem preventing you from getting out because I just went to the URL's that Kevin provided and they loaded just fine in my browser.


Aug 4 '09 #15
the things work fine for me . the only thing is did was uninstalling active perl and deleting all files associated with it and installing it again. the thing i guess was some perl files were on this computer and i installed it again . :-). happy endings.
thankyou kevin and Jeff.
Aug 4 '09 #16
4,059 Expert 2GB

Very good, that would have have been my next suggestion, check for more than one install of perl. If you have a modern computer strawberry perl seems to work good. The newest version even comes with DBI and the mysql drivers already included, which I am pretty sure activeperl doesn't, although that might not be a benefit for you.

But if you decide to try strawberry perl you have to uninstall activeperl first.
Aug 4 '09 #17
Thanks for the suggestions
Aug 4 '09 #18

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Ramesh | last post: by
2 posts views Thread by Mahesh.V | last post: by
2 posts views Thread by python_eager | last post: by
9 posts views Thread by Keith E. Sauvant | last post: by
1 post views Thread by rohitbasu77 | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.