>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement