Re: Latest ODBC driver? / lo (blob) problem with fieldtype in Delphi

Thanks for the reply's dave. I'll give them a try.

About the blob/lo problem. I'm not sure if this problem is strictly a Delphi issue. It seems that in the backend for version 8.0 (maybe a bit before that, I'm not sure), the implementation for the lo-datatype changed. Now it's a domain, before you had to create your own type named lo to have a field capable of storing (Binary) Large OBjects. Somehow the field is now recognized in Delphi as an IntegerField, and no longer as a field for large objects.

Just a thought of mine, but maybe the implementation in the backend changed, so the ODBC recognizes and passes the field as type integer, and no longer as a lo/blob field.
Otherwise it's something in the implementation of the ODBC driver itself that passes the field type as something that delphi understands as integer, maybe the odbc really says it's an integerfield.

I'll try the 08.02 and see what that does.

Regards,

Stijn.

> > 3. The problems we are having are related to lo (BLOB)
> fields. Maybe
> > somebody can tell me if this is indeed related to the
> version of the
> > ODBC drivers.
> > I'm using Delphi in combination with ADO as a development
> enviroment.
> > I make my databaseconnection using a TADOConnection
> component. Next I
> > use a TADODataSet where I perform my database operations. I
> can't work
> > with fields of the type LO because in delphi the fieldtype
> needed for
> > this is a TBlobField, but the real problem is that all lo
> fields get
> > recognized as a TIntegerField. This means that I can't use
> any of the
> > operations for working with BLOB's... I don't know if it
> are Delphi's
> > ADO components who incorrectly recognize the fieldtype, or the ODBC
> > driver, or the backend. We have worked with Delphi, ODBC and BLOB
> > fields before without problems. We started using the 08.01 branch
> > along with the 8.x backend, since this one is the first one
> available
> > for Windows. It could be a change in the ODBC, or the
> backend, I don't
> > know. Any tips or clarification to put me on the right search path
> > would be welcome.
>
> I never used BLOBs (or Delphi) so cannot help with that I'm afraid.