Can't access Visual Foxpro Remote View from Active Server Page

[DTRNTR]

Greetings ODBC Gurus!

I have a Visual FoxPro Database with a Remote View to a FoxPro 2.6 Table (Employees). From the command window, within VFP, I can access this remote view and join it with other local tables without any problem.

When I reference the Remote View from an Active Server Page I receive the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Visual FoxPro Driver]Function is not supported on remote tables.

The sql causing the error is simply 'Select * from Employee', so not sure what 'Function' means in above error message.

I am having no trouble accessing other non-remote tables in my Visual Foxpro database.

Thanks in advance for any help you can provide!

 

[eugenghiulea]

You simply can't, don't try any more. Function is not supported on remote tables.