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

I have installed the 08.02.0002 snapshot after uninstalling the 08.01.
It looks like the problem is now solved. Not only do the Delphi ADO
components recognize my lo field as TBlobField, but it even works within
a transaction (which is nice because we had some problems there in the
past).

I did check the 7.4+ protocol option, which was enabled. If anyone needs
it or has a similar problem, I can post my connection settings (since
they seem to work), just let me know.

As I understood the 08.02 branch is going stable in the near future. So
before going into production with this I'll be anctiously waiting for
that to happen. Escpecially because Dave said the driver name will
change before the release.
Quote Dave Page: "Note that the driver name will probably change before
release, but will be set in stone once the first 08.02 stable release is
out."

Thanks for the reply's. I'm a happy developper again, I can finally
ditch the MSSQL Desktop backend ;)

Regards,

Stijn Vanroye.

Hiroshi Inoue wrote:
> Stijn Vanroye wrote:
>> 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.
>
> Please check 7.4+ Protocol option when you try lo domain type.
>
> regards,
> Hiroshi Inoue
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>