Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
>>I access from SQL to VFP data. I have created a linked server and i wrote a stored procedure with a command like this
>>
>>UPDATE OPENQUERY(VFP, 'SELECT Ido, Ccf FROM myTable WHERE Ido=16949') Set Ccf='ABC'
>>
>>When i execute this stored i see in messages windows of sql server that all commands have been executed but if i requery the data the column ccf has not been modified.
>>
>>I use Visual Foxpro OLEDB provider versione 9 Sp2.
>>
>>I am very new to sql server, where is my error ?
>>
>>Thanks
>
>Michele,
>VFPOLEDB doesn't support updating via a linked server. If you use OpenRowSet() instead it gives error but updates.
>
>I wouldn't use VFP with SQL server (it creates other constraints as well). In my honest opinion move completely to SQL server.
>
>Cetin
Thanks, the problem is that i have two applications. Thefirst works in SQL server and the other in VFp. I have to build Stored procedure to update vfp tables, but alternatively i can modify the vfp application to read data from sql server and the update vfp tables. The ideal solution was from sql but i can do it in the other way. It is also intersting to know that oledb provider dosen't permit to make operation to write tables of vfp.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement