It works in my test.
-- Created linked server to VFP Northwind DBC
sp_addlinkedserver
@server = 'VfpNorthwind'
, @srvproduct = 'VFP'
, @datasrc = 'C:\Program Files\microsoft visual foxpro 9\Samples\Northwind\northwind.dbc'
, @provider = 'vfpoledb.1'
-- Query view orders_qry
SELECT * FROM VfpNorthwind...orders_qry
What is different on your side?
The linked server uses ODBC or VFP OLE DB provider? What version?
Does view have parameters?
>Given :
>- sql server with a VFP database as linked server
>- a query through this linked server on a VFP view
>- when the view is executed from VFP : it returns the correct data
>
>Problem :
>- no data is returned when the view is executed through the linked server. I get no error, just an empty cursor with the correct structure.
>
>Question :
--sb--