Hi all!
I have a link to VFP data that I made using the sp_AddLinkedServer stored procedure, like this:
sp_addlinkedserver @server='VFPData', @srvproduct='', @Provider='MSDASQL',
@provstr='DRIVER={Microsoft Visual FoxPro Driver};Deleted=Yes;Exclusive=No;SourceType=DBF;SourceDB=\\Server\Share\dir\'
Next, I can access my table using:
select * from openquery(VFPData, 'SELECT * FROM TableName')
Excellent!
Now, what if I want to update, insert or delete? In theory, I could use server.schema.owner.table, but what is the schema and owner of VFP data?
Thanks!
Sylvain Demers