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

From: Tongpran D. Lo <tongpran_at_hotmail.com>
Date: 1 Aug 2002 08:30:36 -0700
Message-ID: <5597a07a.0208010730.58da83ad_at_posting.google.com>


Hi Michael,

    Thanks for your advice. However, I had tried on it and it still doesn't work at all. Couldn't you please let me know more detail of it. The same source code, it works perfectly with Oracle and MS-Access, but not in Ingres. Anyway, Ingres is set autocommit off by default.

mleo_at_cariboulake.com (Michael Leo) wrote in message news:<4.3.2.7.2.20020731074044.02e7d810_at_127.0.0.1>...
> 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
Received on Thu Aug 01 2002 - 17:30:36 CEST

Original text of this message