VFP OLE DB Provider supports read only access in a linked server.
>I'm using a 64bit application on my 64bit Sharepoint box and a 32bit SqlServer2005 on a Win2003 box where I also have various folders with VFP free tables that I want to access. I can create a linked server and select VFP data just fine. My problem arises when I attempt to update those same VFP Tables.
>In the Attached images, Image 2 shows the Error that is returned when attempting to do the Update.
>Image 1 is the Linked server scripted with all the server options.
>Image 3 shows 1. The query to the Add LinkedServer stored procedure with parameters passed to it. AND 2. the Update query with which I get the error in image 2.
>
>The Select queries work fine. Am I missing a server option setting? Has anyone seen this before?
>
>Thanks In Advance
--sb--