Home > Archive > PERL Beginners > May 2004 > perl / unixODBC and Oracle 9i
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
perl / unixODBC and Oracle 9i
|
|
| Shaunn Johnson 2004-05-19, 1:30 pm |
| Howdy:
I'm running Perl 5.8.x on RHEL ver. 3 and I am
trying to connect to Oracle 9i (both
the database and the Application Server's
repository).
With Perl 5.6.1, I used DBI and Oracle:DBD
and things worked well, with Perl 5.8.x, the
readme docs for the DBD module says that it
is incompatible with that version of Perl.
I thought I could use unixODBC on Linux to
connect to the database(s), but I don't see
any docs or examples (even from unixODBC.com)
that could help.
Can someone point me in the direction to either:
a) configure a new version of Oracle DBD to
work, or,
b) examples of how to get Perl 5.8.x, unixODBC
and odbc-oracle-1.3.1 to work on RedHat Linux,
or,
c) point me towards a how-to to re-install a
second perl version on the same box. (I am
trying this route, and get compile errors - I
can send those if they are needed).
Please and thanks!
-X
| |
| Bob Showalter 2004-05-19, 2:30 pm |
| Johnson, Shaunn wrote:
> Howdy:
>
> I'm running Perl 5.8.x on RHEL ver. 3 and I am
> trying to connect to Oracle 9i (both
> the database and the Application Server's
> repository).
>
> With Perl 5.6.1, I used DBI and Oracle:DBD
> and things worked well, with Perl 5.8.x, the
> readme docs for the DBD module says that it
> is incompatible with that version of Perl.
Where specifically are you reading that? I'm pretty sure DBD::Oracle is
compatible with Perl 5.8. Have you tried it? What specific problems are you
having? Have you searched the archives of dbi-users?
(http://lists.perl.org/showlist.cgi?name=dbi-users)
| |
| Shaunn Johnson 2004-05-19, 6:30 pm |
| --Bob
--you were correct - the crack i was smoking was tainted.
--most of my issues revolved around what the build
--couldn't locate (mostly the headers and the *.mk files)
--that didn't come with the App Server. Perl had a
--message that was specific to 5.8, but i can't
--find it (of course) - i posted this to the Oracle
--list to see if they had any ideas; gonna report back
--to them and let them know what i did.
--also, the READMEs had me  . The DBI readme
--said to "Check that a DBD::* module exists for the
--database you wish to use". i took that to mean that
--DBD should be installed first. the DBD README said to
--make sure DBI was installed. i think that i got a
--specific error message that lead me to believe it
--was a 5.8.x issue (heck, i even asked another admin
--who said he came to the same conclusion!).
--i had to do some slight-of-hand thing to get it
--to work, but it's working fine.
--thanks!
-X
-----Original Message-----
From: Bob Showalter [mailto:Bob_Showalter@taylorwhite.com]
> Howdy:
>
> I'm running Perl 5.8.x on RHEL ver. 3 and I am
> trying to connect to Oracle 9i (both
> the database and the Application Server's
> repository).
>
> With Perl 5.6.1, I used DBI and Oracle:DBD
> and things worked well, with Perl 5.8.x, the
> readme docs for the DBD module says that it
> is incompatible with that version of Perl.
Where specifically are you reading that? I'm pretty sure DBD::Oracle is
compatible with Perl 5.8. Have you tried it? What specific
problems are you
having? Have you searched the archives of dbi-users?
(http://lists.perl.org/showlist.cgi?name=dbi-users)
|
|
|
|
|