Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One thread, 2 questions, on Firebird use & ODBC VFP supp
Message
From
26/05/2004 08:58:27
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
 
To
26/05/2004 08:11:54
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00907196
Message ID:
00907298
Views:
12
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)

>
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform