Re: int8 Informix and 64bit perl



Jonathan Leffler wrote:
On 9/27/07, Clive Eisen <clive@xxxxxxxxxxxxxxx> wrote:
Jonathan Leffler wrote:
On 9/27/07, Clive Eisen <clive@xxxxxxxxxxxxxxx> wrote:
I seem to have a problem with negative int8 on a 64 bit linux platform

dbaccess gives the correct answer but DBD::Informix does not

informix@ifx1:~> oninit -V
IBM Informix Dynamic Server Version 10.00.FC6

informix@ifx1:~> esql -V
IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.FC4R1

informix@ifx1:~> perl -v

This is perl, v5.8.8 built for x86_64-linux

informix@ifx1:~> perl -MDBI -e 'print "$DBI::VERSION\n"'
1.53

informix@ifx1:~> perl -MDBD::Informix -e 'print "$DBD::Informix::VERSION\n"'
2007.0914

[...]

Unfortunately (for you - fortunately for me), Perl 5.8.8 with 64-bit
CSDK 3.00.FC2 on Solaris 10 correctly produces the negative answer.

That means that to some extent, the problem is platform specific.
I'll try to build DBD::Informix with CSDK 2.90.FC1 later - I have to
rig the build environment on my machine to do that. It might be CSDK
2.90 vs 3.00; it might be Linux x86 vs Solaris SPARC.

Rigged environment - it works correctly on Solaris under CSDK 2.90.FC1.

Please can you send me 'perl -V' output - I suggest taking dbi-users
off this chat until we have a resolution.

FYI 32bit client using 2.90.UC4 works correctly on linux against the
same DB server

So it is a client-side problem - CSDK or DBD::Informix - and not a
server problem.


Indeed - it's a reproducible problem in ESQL Version 2.90.FC4R1
and is confirmed in my tests to be fixed in ESQL Version 3.00.FC2

So if you use esql on 64bit Linux I suggest you upgrade to 3.00.

Thanks again for your help Jonathan.

--
Clive



--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

.



Relevant Pages

  • Re: SDK license
    ... To connect from PCs to the Server you do not need I-Coonect, ... I-Connect is effectively the runtime tool for CSDK ... My questions to you is "Do they need to buy the license for IBM Informix Client SDK for windows 2000, before downloading it" or is license already included with the original informix database software? ...
    (comp.databases.informix)
  • Re: SDK license
    ... To connect from PCs to the Server you do not need CSDK, ... I-Connect is effectively the runtime tool for CSDK ... My questions to you is "Do they need to buy the license for IBM Informix Client SDK for windows 2000, before downloading it" or is license already included with the original informix database software? ...
    (comp.databases.informix)
  • Re: int8 Informix and 64bit perl
    ... IBM Informix Dynamic Server Version 10.00.FC6 ... IBM Informix CSDK Version 2.90, ... CSDK 3.00.FC2 on Solaris 10 correctly produces the negative answer. ...
    (perl.dbi.users)
  • PHP & Informix on Red Hat Enterprise 5
    ... I?m trying to connect to an IDS 10 on another server. ... Set INFORMIXDIR & LD_LIBRARY_PATH to point to the Zend Core directory. ... Then I downloaded the CSDK and pointed both to the CSDK install directory. ... But this didn?t set them in PHP. ...
    (comp.databases.informix)
  • Re: int8 Informix and 64bit perl
    ... dbaccess gives the correct answer but DBD::Informix does not ... IBM Informix Dynamic Server Version 10.00.FC6 ... IBM Informix CSDK Version 2.90, ... CSDK 3.00.FC2 on Solaris 10 correctly produces the negative answer. ...
    (perl.dbi.users)