You can also try SIBprovider OLE DB provider for Firebird/Interbase, maybe will work
www.sibprovider.comThey have a trial veriosn (60 days) but is very cheap (30 $ for unlimited clients installs)
>
>>SQLEXEC(nConnHnd , [UPDATE {table} set {BLOB_COLUMN} = ?m.ImageContent WHERE ...])
>works, but , when retrieved back in a remote view, is corrupted.
>That exactly what i found, Dorin!
>
>>(I don't know how to determine VFP not to use General field in SPT for >this)
>
>In order to make sure that VFP use a MEMO NOCPTRANS instead of the GENERAL format, I tried the update thru a CursorAdapter-based cursor as well. With a properly mapped field (MEMO NOCPTRANS ). Same Bug on upload.
>
>Curiously enough, i was more successful when running thru a DBC-based remote view. But this application is fully dynamic. Data access is generated on-the-fly from a meta-model and there's no room for dbc in this app(:
>
>>Somewhere between VFP -> ODBC or ODBC -> server >something take place, I >don't know what. But the guy who answer usually on the newsgroup must >know. That's why I told you to send a message there.
>
>>If you provide him an ODBC trace log, he can fix rapidly, if is ODBC driver fault, and release >another usable build.
>
>I'll try. Thank you for your support.
>
>François