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