Failed DBD oracle module

2013-09-23 Thread Lieng, Gia
Hi, I had installed perl 5.18.1 and two other modules DBI and DBD::Oralce. And using the simple script below to test both modules, DBI worked but DBD::Oracle gives the following errors. Both modules compile and installed without errors. - Testing module DBI worked: $ vi

Re: DBD::Oracle installation on AIX

2013-09-23 Thread Martin J. Evans
On 22/09/2013 22:41, Nagendra Singh wrote: Hi Martin, Thanks a bunch for looking into this problem. Here are the details asked by you:- PERL Version is v5.10.1 DBI Version is 1.609 DBD::ODBC version is 1.43. Logs file are attached. Regards, Mr. Singh Thank you for the trace file. Your versions

Re: DBD::Oracle installation on AIX

2013-09-23 Thread Martin J. Evans
On 23/09/2013 18:43, Nagendra Singh wrote: Thanks Martin. How can I get UnixODBC trace? Could you please let me know the command. Strange thing is on one Linux machine its working fine and on another Linux machine( Same configuration) its not. Result of odbcinst-j is:- UnixODBC2.2.14 Drivers:

Re: Failed DBD oracle module

2013-09-23 Thread Bruce Johnson
On Sep 20, 2013, at 8:57 AM, Lieng, Gia gia.li...@au.fujitsu.com wrote: $ perl perl_test.script Can't load '/usr/local/lib/perl5/site_perl/5.18.1/sun4-solaris/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: perl: fatal: /opt/oracle/10.2.0.3/lib/libclntsh.so.10.1: wrong ELF

Re: Failed DBD oracle module

2013-09-23 Thread Bruce Johnson
On Sep 23, 2013, at 2:02 PM, Bruce Johnson john...@pharmacy.arizona.edu wrote: This can happen if you have 32-bit oracle db installed on the system, but use the 64-bit Oracle Instant Client to compile DBD::Oracle. Or Vice-versa, of course, which might be what your problem is. -- Bruce