Posted by Jens on 01/22/06 11:53

Thats quite normal, but you are able to use the four part notation,
which will switch to another database if specified.

E.g. ODBC Connection points automatically to Northwind ( as the default
database of the user) you can use

SELECT <columnlist> FROM Linkdservername.Databasename.Objectname

which switches to the other database to select.

HTH, Jens Suessmeyer.

• Next in forum: Re: ODBC Connection to a linked database
• Prev in forum: ODBC Connection to a linked database
• Thread view: Re: ODBC Connection to a linked database

[Reply to this message]