Xavier,
>I have created a .NET dll called from an aspx page all works very well accessing vfp data but as soon as my dll wants to read MS access data via a remote view in the DBC (Using ODBC) I get the following message.
Although you can access views with the VFP OLE DB Provider, there are some limitations. Here are the basics:
1. You can access local views using the following syntax:
SELECT * FROM
or
USE
2. You cannot use remote views from the VFP OLE DB Provider
3. You cannot use parameterized views (a serious limitation). You have to remove parameters from the view and supply them as part of the query. For example:
SELECT * FROM lv_Orders WHERE OrderID = 1000
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com