>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.
>

Folks,

Ok people... I made a little progress here. I don't know why, but I tried this on another PC (Win 98) and was able to see the Fox tables in the SQL Enterprise Manager.

Now the problem is that I can't seem to query the data. The linked server is named NJDATA. So, I try the following query. (In a view or Query analyzer I get an error message.)

Here is my query...

select a.* from njdata...eemast as a

The error message is...

Invalid schema or catalog specified from provides 'MSDASQL'.

If I try something like...

select a.* from njdata..dbo.eemast as a


I get...

Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four part name was supplied, but the provider does not expose the necessary interfaces to use catalog and/or schema.

Any ideas folks.

Thanks,
BOb