Please help me connect to Oracle

[mikedaruke]

Can anyone give me directions to install DBD-Oracle on a Windows box? The box doesnt have oracle running on it, oracle is running a seperate linux box.

I need to connect and do queries and this install fails no matter how I try.

Has anybody had any luck with it? If I can't get it is there any other module or way to connect to a Oracle DB?

 

[travs69]

What perl are you running? It is in PPM for AS.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[mikedaruke]

I do have PPM but no internet connection.

So I can download a ppm module and install but when I do that I get that awful message that i dont know why.

ppm install DBD-Oracle.ppd

Get all good stuff, then the terms I have to accept. then this

Bizarre SvTYPE [24] at ./ioic line 116.
unlink C:\Perl\bin\ora_explain
unlink C:\Perl\bin\ora_explain.bat
unlink C:\Perl\site\lib\DBD\Oracle.pm
unlink C:\Perl\site\lib\DBD\Oracle\GetInfo.pm
unlink C:\Perl\site\lib\Oraperl.pm
unlink C:\Perl\site\lib\auto\DBD\Oracle\Oracle.bs
unlink C:\Perl\site\lib\auto\DBD\Oracle\Oracle.dll
unlink C:\Perl\site\lib\auto\DBD\Oracle\Oracle.exp
unlink C:\Perl\site\lib\auto\DBD\Oracle\Oracle.h
unlink C:\Perl\site\lib\auto\DBD\Oracle\Oracle.lib
unlink C:\Perl\site\lib\auto\DBD\Oracle\Oracle.pdb
unlink C:\Perl\site\lib\auto\DBD\Oracle\dbdimp.h
unlink C:\Perl\site\lib\auto\DBD\Oracle\mk.pm
unlink C:\Perl\site\lib\auto\DBD\Oracle\ocitrace.h
unlink C:\Perl\site\lib\oraperl.ph
unlink C:\Perl\site\lib\auto\DBD\Oracle\.packlist
Can't remove directory C:\TEMP/DBD-Oracle-1-3528-1192108293: Permission denied a
t C:/Perl/site/lib/PPM/Repository.pm line 247
Error: system() returned non-zero value (65280): 'C:\Perl\bin\perl.exe
install_script'

 

[travs69]

I have never done it that way. You might go to activestates forums and ask about it. It seems just like a basic windows permissions error. Are you an admin?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[stevexff]

Sounds like you need to be a local admin for the machine.

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]