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