I would have to agree with Martin that the you should really try to get
DBD::Oracle working on you 64 bit box I am sure if you uwe the 32 bit
instant client it will work for you .
Check some of the previous posts on this lits lots of people use the
DBD::ORacle on 64 bit Solaris boxes.
Cheers
John Scoles
Martin Evans wrote:
Tofigh, Mike (NIH/NEI) [C] wrote:
Hello:
>
I have project in my hand that I am not getting anywhere with it for
past few months.
I have CGI application runing using appache, DBD::oracle, DBI, and
Perl 5.8, in Solaris 8, running with ORACLE 9i
I have upgrade ORACLE 9i to oracle 10g and solaris OS to Solaris 10 64
bits machine, but DBD::oracle does not work with 64bit perl and oracle
64 bit libs, it seems oracle 10 does not have 32 lib anymore...,and
DBD::ORACLE does not work with oracle 10g.
I am using DBD::Oracle successfully on a number of machines with
instant client libraries. Instant client libraries are available
separately from Oracle and you can get 32bit and 64bit versions. The
instant client libraries can be installed very easily (just an unzip)
and can be used independently of Oracle database itself.
Have you tried DBD::Oracle with the instant client libraries? When you
say:
"DBD::oracle does not work with 64bit perl" - what does not work?
"DBD::ORACLE does not work with oracle 10g" - what does not work?
I decided to look at DBD::ODBC as alternative what is your thought and
direction on this issue.
I have look at easysoft and iodbc, but somehow I am not too sure about
it.
For greatest functionality in Oracle you are better off with
DBD::Oracle (assuming you can get it to work). If however, you are
writing code that connects to Oracle and a) connects to other
databases too or b) might connect to other databases in the future,
then DBD::ODBC may be a solution for you. Easysoft (N.B. - my
employer) have 32 bit and 64 bit Oracle ODBC drivers and I believe
Oracle distribute their own ODBC drivers for Linux and Solaris
(although I'm not sure about 64bit availability). As the current
maintainer of DBD::ODBC I would recommend you use unixODBC as a driver
manager - there are many reasons for this some of which are listed at
http://www.easysoft.com/developer/interfaces/odbc/linux.html.
If I were you I'd give us more information about what does not work
with DBD::Oracle on 64bit Solaris with Oracle 10g and we can look at
that first.
Martin
