>Hi All,
>
>I am trying to use linked server feature of SQL 7.0 to link to an ODBC data source of a FoxPro 2.6 datasource that I have set up.
>
>I am able to create the link server, but nothing is listed under the tables leaf on the tree view in Enterprise Manager.
>
>I ultimatly want to create a SQL view using a distributed query against the linked server (Fox data).
>
>Has anyone been able to do this, or perhaps what I could be doing wrong. I have tested the ODBC DSN in FoxPro and I am able to create remote views and see that data fine.
>
>Any help would be appreciated.
>
>BOb


Hi Bob -

Are you sure your not looking to do a heterogenous query? My understanding is that linked servers are remote SQL Server servers, not other data sources. Via a heterogeneous query, you able to hook a VFP/FP datasource into SQL Server, then query that datasource through SQL Server.

If that what your looking for, check MSDN and the keyword: heterogeneous (if I am spelling that correctly <g>)

Mike