I hope to get some help from VB developers that using Informix DB with remote ODBC connection.
I am using IBM Informix 3.82 32 bit odbc driver (Win2000) to hit Informix 7.32.HCI database that is running on UNIX HP box.
ADO.command statment truncates long string when, inserts it into Informix blob table.
This only happens when the component (COM DLL writen in VB) runs as COM+ object in MTS.
If the same code SQL statment is executed from .ASP page it works fine.
I used ADO.command and ADO.recordset classes to insert the record with a long string (XML), and got same result. It truncates last 60 -80 characters out of 600 - 700 characters long XML.
It looks like the driver bug.
Please let me know if you've seen this before.
Roman.
I am using IBM Informix 3.82 32 bit odbc driver (Win2000) to hit Informix 7.32.HCI database that is running on UNIX HP box.
ADO.command statment truncates long string when, inserts it into Informix blob table.
This only happens when the component (COM DLL writen in VB) runs as COM+ object in MTS.
If the same code SQL statment is executed from .ASP page it works fine.
I used ADO.command and ADO.recordset classes to insert the record with a long string (XML), and got same result. It truncates last 60 -80 characters out of 600 - 700 characters long XML.
It looks like the driver bug.
Please let me know if you've seen this before.
Roman.