Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Link Server Update Error when saving to DBF
Message
 
 
À
15/05/2009 14:50:26
Gil Munk
The Scarborough Group, Inc.
Baltimore, Maryland, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01400194
Message ID:
01400201
Vues:
40
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform