Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linked server returns no data on a view
Message
 
 
To
21/10/2005 03:53:10
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01060997
Message ID:
01061359
Views:
10
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform