Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Question Unanswered: trailing zeros truncate

    I have installed odbc on my windows 2000 it is working fine. I can able to log on to my informix database which on unix.

    Problem is when I retrieve rows from tables. It is truncating zeros.

    For ex: If I write sql "select count(*) from xyztable" if there are 10 rows in the table. it is returning 1 row. If 20 rows it is returning 2 rows.

    What could be the problem ? ... whether it is problem with driver or setup.


    The same setup is working fine on few win98 systems. but not on all win98 systems.

    Please help me.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: trailing zeros truncate

    Originally posted by torch2moon
    I have installed odbc on my windows 2000 it is working fine. I can able to log on to my informix database which on unix.

    Problem is when I retrieve rows from tables. It is truncating zeros.

    For ex: If I write sql "select count(*) from xyztable" if there are 10 rows in the table. it is returning 1 row. If 20 rows it is returning 2 rows.

    What could be the problem ? ... whether it is problem with driver or setup.


    The same setup is working fine on few win98 systems. but not on all win98 systems.

    Please help me.
    Hi,

    Please can you install new version of Ibm-Informix Client-SDK 2.81 TC2.

    Gustavo.

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Re: Re: trailing zeros truncate

    Dear gurey

    Thanks for your reply and attending to my query.

    Actually I am new to this.....

    Please tell me that, At present I have installed only informix setnet32 & made odbc setup. I have not installed SDK but, connection is working fine in ASP & visual basic....except zero truncation. Do you feel that is it because non installation of SDK ?

    Can you tell me, from where I can download new version of Ibm-Informix Client-SDK 2.81 TC2.
    And what setup I should make to prevent this zeros truncation.

    Thanks in advance

    torch2moon

  4. #4
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: Re: trailing zeros truncate

    Originally posted by torch2moon
    Dear gurey

    Thanks for your reply and attending to my query.

    Actually I am new to this.....

    Please tell me that, At present I have installed only informix setnet32 & made odbc setup. I have not installed SDK but, connection is working fine in ASP & visual basic....except zero truncation. Do you feel that is it because non installation of SDK ?

    Can you tell me, from where I can download new version of Ibm-Informix Client-SDK 2.81 TC2.
    And what setup I should make to prevent this zeros truncation.

    Thanks in advance

    torch2moon
    Hi,

    You can download Client SDK 2.81 from the IBM site. The link is -
    http://www14.software.ibm.com/webapp...ndBetas&S_CMP=

    Regards,

    Lloyd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •