Here is the error I get when I run the application at ..../cgi-bin/NEI/ibank_lib.dbi line 24 install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: perl: fatal: ..../app/oracle/product/10.2.0/db/lib/libclntsh.so.11.1: Permission denied at /usr/local/lib/perl5/5.8.8/sun4-solaris-thread-multi/DynaLoader.pm line 230. at (eval 12) line 3
Thanks for your help Mike Tofigh Digicon Contractor (301)-213-6640 -----Original Message----- From: Martin Evans [mailto:[EMAIL PROTECTED] Sent: Mon 9/8/2008 11:52 AM To: Tofigh, Mike (NIH/NEI) [C] Cc: [email protected] Subject: Re: DBD::oracle DBD::ODBC DBI 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
