Re: Couldn't save binary BLOB object more than 38KB
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."
Received on Thu Aug 01 2002 - 17:30:36 CEST