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.

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