where can I get instance client lib from 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
_____________________ 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 -- Martin J. Evans Easysoft Limited http://www.easysoft.com
