>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 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). IMHO move completely to SQL server.
Cetin