Hi
I think that the problem can be solved outside ODBC related to BLOB upload, relying only on API.
I've searched the C++ API and there are some usable functions. isc_create_blob2(), isc_put_segment(), isc_close_blob() which can be used to create a BLOB space in database and write into it. Then , given the BLOB_ID returned by the first function, all is needed is to execute an update statement to set the BLOB column to this BLOB_ID (at least this is what I read there)
As I'm interested and I'm somehow familiar with how API works, I'll try to expand my Firebird API wrapper class with this functionality. If I succed, I'll post an updated version or I'll send you the class by e-mail.
Cheers.
>>You can also try SIBprovider OLE DB provider for Firebird/Interbase, maybe will work
>>
www.sibprovider.com>>
>>They have a trial veriosn (60 days) but is very cheap (30 $ for unlimited clients installs)
>
>Good to hear:) But for the moment i stick to ODBC, firmly! ODBC is an int'l standard, OLE DB is an MS-only thing.
>
>The reason: we have a part of the application running great both on linux and win32 (apache+python servlet). It uses odbc (no chance to run OLE DB on linux). I wish to remain consistent in terms of database access.
>
>The long-term view is to migrate the application to a cross-platform tool (current evaluating python+wxwidgets).
>
>Regards