>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only