> Hallo Together,
>
> I´d like to replicate my Data from my Foxpro Application to a SQL Server 2005. The problem I got is that it is not possible to bring OLE Objects form a "General- Field" Column into the SQL Server 2005. The Column in the SQL Server 2005 has a image Column Datatype. I also have tried the varbinary(Max) Datatype without success.
>
> Can anyone tell me how i can realize this?
>
> Thanx in advance
>
> Stefan
The SQL 2005 column would be image or varbinary(max). Nothing wrong there.
But if you do that with General fields you're storing some Ole header besides the file itself (or simply the header + path to file which would later fail to work). If possible get rid of general fields and use memo or blob for that on VFP side. You can transfer them to SQL2005 image/varbinary(max) columns using CreateBinary(). Load back using MapBinary = .t. as a BLOB.
Cetin Basoz