strange problem connecting oracle db

[kanishka1213]

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.

[KevinADC]

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.

[kanishka1213]

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.

[KevinADC]

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.

[kanishka1213]

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..

[KevinADC]

add more repositories to the PPM application. See the PPM documentation.

Here is three good repositories:

http://theoryx5.uwinnipeg.ca/ppms/
http://www.bribes.org/perl/ppm
http://trouchelle.com/ppm/

[KevinADC]

@kanishka1213
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.

[kanishka1213]

i download this and installed it
ActivePerl-5.10.0.1005-MSWin32-x86-290470.msi

so on my computer it create a folder for perl this way
C:/perl/bin/perl.exe

[kanishka1213]

when i try to add the repositories u gave from ppm it shows me fail .:-(

[kanishka1213]

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,

[KevinADC]

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

http://docs.activestate.com/activepe...Perl-faq2.html

[KevinADC]

@kanishka1213
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.

[kanishka1213]

when i add this to the repository
http://www.bribes.org/perl/ppm/

it gives me error
downloading file failed 500 cannot connect to www.bribes.org:80
(Bad hostname :www.bribes.org)

[KevinADC]

That could be a firewall or proxy server problem. Read the "PPM, Proxies and Firewalls" section of the PPM documentation.

http://docs.activestate.com/activepe...pm_and_proxies

If that is not the problem, I don't know.

[numberwhun]

@KevinADC
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.

Regards,

Jeff

[kanishka1213]

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.

[KevinADC]

@kanishka1213

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.

[kanishka1213]

Thanks for the suggestions