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

Sorry, but I just happen to know that OpenIngres 2.0 has problems with blobs with autocommit turned on. I don't know anything about the internals of the CA ODBC driver.

You will need to call support to get this fixed, likely.

Sorry.

Michael Leo

At 08:30 AM 8/1/2002 -0700, Tongpran D. Lo wrote:
>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 - 18:18:48 CEST