Using SQL Server, I have created a Linked Server to a VFP free table directory. Also, on the SQL Server machine I have created a System DSN that points to the VFP free table directory.

If I use the SQL Server Analyzer, I can query a VFP with the following syntax:

SELECT * FROM OPENQUERY(MyDSN, 'SELECT * FROM myvfptable')

My question is, how do perform this query from another machine?

Our web app needs to perform the above query from the web server. I created a System DSN that points to the SQL Server that contains the linked server. But how do I perform the above query against that SQL Server?

Does anyone have an example?

Thanks,

Jerry