>try select * from NJDATA.catalogname..EEMAST
>
>The trick is to define a catalogname when you define the linked server
>
>Good Luck!
>Mike
Did you get this to work? I tried it, just put a catalog name in the Create Linked server dialog... Then I tried my query:
select * from njdata.catbob..eemast
And I get the error:
OLE DB provider 'MSDASQL' does not contain table "'catbob'\'eemast'".
BOb
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