Re: Couldn't save binary BLOB object more than 38KB

At 10:04 PM 7/30/2002 -0700, Tongpran D. Lo wrote:
>I have defined one table with one column the data type is "long byte".
> By using ADO data access method with "AppendChunk", I couldn't
>insert the binary data more than 38K byte in this "long byte"
>column. Also, the CA-Ingres ODBC driver showed me the error message
>as below :-
>Run-time error '-2147467259(80004005)': [CA][Ingres ODBC Driver]
>String data right truncation.
>
>However, below 38K byte binary data. This OpenIngres 2.0 can accept
>it. We are using OpenIngres 2.0 on Solaris platform and this program
>is written by Visual Basic.
>
>Any help ????????
>
>Thanks...

Try turning autocommit off. It is a long shot, but I have seen it work.

Cheers,

Michael Leo mleo_at_cariboulake.com Java, J2EE Caribou Lake Software http://www.cariboulake.com Oracle, Ingres,

                                                    DB2, Websphere

"We should forget about small efficiencies, say about 97% of the   time: premature optimization is the root of all evil."

• Donald Knuth