>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

Re: SQL 2005 Linked Server SLOW Thread #1145359 Message #1145696

http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c08ppcsq.mspx

Re: Sub Query not working Thread #1176038 Message #1176045