>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
Can you call stored procedure with your Select command inside?
Edward Pikman
Independent Consultant