> 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
This is one of the reasons to NEVER use General fields. You can put things into a general field, but it is hard to get them back out :(
In VFP, your best bet is to use a Blob field and in VFP FILETOSTR() to save the object or STRTOFILE() to display the object. What are you storing in that general field? That will determine how you should store it in SQL.
Ken
You shall know the truth - and the truth shall set you free. (John 8:33)