Home: Perl Programming Help: DBI:
DBD:Oracle downgrade



mixter336
Novice

Sep 1, 2009, 1:45 PM


Views: 10847
DBD:Oracle downgrade

I have a new version of perl on my server and it has DBI 1.607 abd DBD:ORACLE 1.21. I am trying to connect to an older version of Oracle which is no longer supported in DBD:Oracle 1.21. I would like to go to version 1.17...how can i do this on a windows machine?


FishMonger
Veteran / Moderator

Sep 1, 2009, 2:03 PM


Views: 10844
Re: [mixter336] DBD:Oracle downgrade

Which Perl distro do you have and what method did you use to install DBD::ORACLE?

If you're using ActivePerl, you can launch the ppm gui and uninstall the current version and then install the older version.


(This post was edited by FishMonger on Sep 1, 2009, 2:03 PM)


mixter336
Novice

Sep 1, 2009, 2:05 PM


Views: 10840
Re: [FishMonger] DBD:Oracle downgrade

That was the route i originally tried to take. I installed ActivePerl as it was an attractive package to get started. When i launch ppm and go to DBD-Oracle the option to remove is greyed out. is there something else i need to do to be able to remove a package?


mixter336
Novice

Sep 3, 2009, 8:56 AM


Views: 10815
Re: [mixter336] DBD:Oracle downgrade

I am having some issues installing an old version of DBD::Oracle.

I removed my old installation of ActivePerl and am starting over on Windows.

Downloaded strawberry perl (active came with a new version of DBD::Oracle that i couldnt remove)
Install DBI through ppm

i downloaded an old version of DBD::Oracle (1.17) how can i install this? Do i need to make a perl module?


FishMonger
Veteran / Moderator

Sep 3, 2009, 11:11 AM


Views: 10814
Re: [mixter336] DBD:Oracle downgrade

You can install it via CPAN. Start the cpan shell, then issue the get command.


Quote
C:\>cpan

cpan shell -- CPAN exploration and modules installation (v1.9205)
ReadLine support enabled


cpan> get DBD::Oracle



mixter336
Novice

Sep 3, 2009, 11:13 AM


Views: 10812
Re: [FishMonger] DBD:Oracle downgrade

this gets the most recent version of DBD:Oracle when i need to install an old version. I have the old version in a .tar.gz file but not sure the best way to install it. i can extract all the files but dont know the installation steps. the readme doesnt help much either.


FishMonger
Veteran / Moderator

Sep 3, 2009, 11:26 AM


Views: 10811
Re: [mixter336] DBD:Oracle downgrade

Sorry.

You need to untar the archive and cd into that directory and then build/compile the module using the following commands (assuming they don't fail).

make (you might need to use nmake or dmake, I don't know which one comes with strawberry perl)

make test

make install


Before you issue those commands, check the README or install file to see if you first need to issue the configure or perl Makefile.pl command.


mixter336
Novice

Sep 3, 2009, 11:59 AM


Views: 10809
Re: [FishMonger] DBD:Oracle downgrade

Thank you very much. used dmake and i am now up and running.