I'd like to set up an ODBC Data Source to a table in a linked SQL
Server, via
my local SQL Server.

When I use the ODBC Data Sources program to set up the ODBC DSN, it
only
shows databases in the local SQL Server, not in the linked one. If I
try typing it in: [NAMEOFLINKEDSERVER].databasename - it tells me that
it is an invalid table.

How can I create an ODBC Data Source which uses a database in the
linked server as its default database?