RE: :Informix esqltest failure

Can you compile a 'simple' esql/c program and run it, using the compiler
with which you are trying to build DBD::Informix? I am assuming this is
the same compiler which built your version of Perl.

As to your note, I'd recommend 'upgrading' your version of Perl. My life
got much easier when I stopped relying on the vendor required version
and built my own version of Perl. I just can't install it in /usr/bin.

HTH,
-Darryl



-----Original Message-----
From: David Kleppinger [mailto:dkleppinger@dts.edu]=0D
Sent: Wednesday, November 02, 2005 3:45 PM
To: DBI List
Subject: DBD::Informix esqltest failure

I'm trying to install DBD-Informix-2005.02 and "perl Makefile.PL" fails
on esqltest with an undefined symbol. You can see the perl/DBI/OS info
in the output below. Informix version is 9.40.HC5. I've tried to run
with INFORMIXSERVER set to an onsoctcp connection and a onipcshm. Both
failed the same way. I'm using the hp ANSI C compiler (not the K&R).=0D
We do have gcc installed too but I've not tried to use it.
I have successfully compiled/run the esqlbasic program.

Note: I'd love to upgrade our perl but can't because a perl/C module
supplied by our major software vendor doesn't work with perl 5.8.x.

==================== =====3D=
===========3D

% perl Makefile.PL
*** ExtUtils::AutoInstall version 0.63
*** Checking for dependencies...
[Core Features]
- DBI ...loaded. (1.48 >=3D 1.38)
[High Resolution Timing]
- Time::HiRes ...loaded. (1.76)
[POD Format Testing]
- Test::Pod ...loaded. (1.22)
*** ExtUtils::AutoInstall configuration finished.
Subroutine WriteMakefile redefined at
/opt/perl5/6/lib/site_perl/5.6.2/ExtUtils/AutoInstall.pm line 491.

Configuring IBM Informix Database Driver for Perl DBI Version 2005.02
(2005-07-29) (aka DBD::Informix)
You are using DBI version 1.48 and Perl version 5.006002
Remember to actually read the README file!

Perl: perl v5.006002 PA-RISC2.0 dl_hpux.xs
System: hp-ux admin1 b.11.11 u 9000800 139434606 unlimited-user
license
*** Ideally, you should upgrade to Perl version 5.008007.

Using INFORMIXDIR=3D/opt/informix and ESQL/C compiler esql Using IBM
Informix CSDK Version 2.80, IBM Informix-ESQL Version 9.52.HC2 from
/opt/informix

Beware: DBD::Informix is not yet aware of all the new IUS data types.

Assert macro will be disabled!

lib/DBD/Informix/Defaults.pm written OK
esqlvrsn.h written OK
esqlinfo.h written OK

Testing whether your Informix test environment will work...
ccflag =3D <<>>
ccflag =3D <<-Ae>>
ccflag =3D <<-D_HPUX_SOURCE>>
ccflag =3D <<-Wl,+vnocompatwarnings>>
ccflag =3D <<+Z>>
ccflag =3D <<-I/usr/local/include>>
ccflag =3D <<-I/opt/gnu/include>>
ccflag =3D <<-D_LARGEFILE_SOURCE>>
ccflag =3D <<-D_FILE_OFFSET_BITS=3D64>>
cppflag =3D <<-DESQLC_VERSION=3D952>>
cppflag =3D <<-DNDEBUG>>
cppflag =3D <<-DUSE_REAL_MALLOC>>
execute_command: esql -c -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +Z
-I/usr/local/include -I/opt/gnu/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64 -DESQLC_VERSION=3D952 -DNDEBUG -DUSE_REAL_MALLOC
esqltest.ec
+ec+ <>
+ec+ <<-c>>
+ec+ <<>>
+ec+ <<-Ae>>
+ec+ <<-D_HPUX_SOURCE>>
+ec+ <<-Wl,+vnocompatwarnings>>
+ec+ <<+Z>>
+ec+ <<-I/usr/local/include>>
+ec+ <<-I/opt/gnu/include>>
+ec+ <<-D_LARGEFILE_SOURCE>>
+ec+ <<-D_FILE_OFFSET_BITS=3D64>>
+ec+ <<-DESQLC_VERSION=3D952>>
+ec+ <<-DNDEBUG>>
+ec+ <<-DUSE_REAL_MALLOC>>
+ec+ <>
+ setenv INFORMIXC =3D /opt/perl5/6/bin/perl esqlcc setenv ESQLCC =3D cc
execute_command: esql -c -Ae -D_HPUX_SOURCE -Wl,+vnocompatwarnings +Z
-I/usr/local/include -I/opt/gnu/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=3D64 -DESQLC_VERSION=3D952 -DNDEBUG -DUSE_REAL_MALLOC
esqlc_v6.ec
+ec+ <>
+ec+ <<-c>>
+ec+ <<>>
+ec+ <<-Ae>>
+ec+ <<-D_HPUX_SOURCE>>
+ec+ <<-Wl,+vnocompatwarnings>>
+ec+ <<+Z>>
+ec+ <<-I/usr/local/include>>
+ec+ <<-I/opt/gnu/include>>
+ec+ <<-D_LARGEFILE_SOURCE>>
+ec+ <<-D_FILE_OFFSET_BITS=3D64>>
+ec+ <<-DESQLC_VERSION=3D952>>
+ec+ <<-DNDEBUG>>
+ec+ <<-DUSE_REAL_MALLOC>>
+ec+ <>
+ setenv INFORMIXC =3D /opt/perl5/6/bin/perl esqlcc setenv ESQLCC =3D cc
execute_command: esql -o esqltest esqltest.o esqlc_v6.o
+ec+ <>
+ec+ <<-o>>
+ec+ <>
+ec+ <>
+ec+ <>
+ setenv INFORMIXC =3D /opt/perl5/6/bin/perl esqlcc setenv ESQLCC =3D cc
/usr/ccs/bin/ld: Unsatisfied symbols:
dbd_ix_opendatabase (first referenced in esqltest.o) (code) Failed
to link test program esqltest # Looks like your test died before it
could output anything.


____________________________________________________________ _______________=
__________

The information contained in this email may be confidential and/or legally=
privileged. It has been sent for the sole use of the intended=
recipient(s). If the reader of this message is not an intended recipient,=
you are hereby notified that any unauthorized review, use, disclosure,=
dissemination, distribution, or copying of this communication, or any of=
its contents, is strictly prohibited. If you have received this=
communication in error, please contact the sender by reply email and=
destroy all copies of the original message. To contact our email=
administrator directly, send to postmaster@dlapiper.com

Thank you.
____________________________________________________________ _______________=
__________