Tofigh, Mike (NIH/NEI) [C] wrote:
where can I get instance client lib from
http://www.oracle.com/technology/tech/oci/instantclient/index.html
What it does not work is the dbd::oracle in the perl program complaint about
can not find. Oracle lib
I will check it and send you the info when I get to the office
Thanks
I
ok.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
_____________________
Mike Tofigh
Digicon Contractor
301-213-6640
Sent from my BlackBerry Wireless Handheld
----- Original Message -----
From: Martin Evans <[EMAIL PROTECTED]>
To: Tofigh, Mike (NIH/NEI) [C]
Cc: [email protected] <[email protected]>
Sent: Mon Sep 08 08:09:28 2008
Subject: Re: DBD::oracle DBD::ODBC DBI
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
