>>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
try select * from NJDATA.catalogname..EEMAST
The trick is to define a catalogname when you define the linked server
Good Luck!
Mike
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