sql server odbc: ODBC Data Source to a linked SQL Server -- sql server odbc

ODBC Data Source to a linked SQL Server

listrecv NO[at]SPAM gmail.com
1/22/2006 6:29:33 AM

sql server odbc: 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?

Re: ODBC Data Source to a linked SQL Server

Randall Arnold
1/31/2006 8:29:07 AM

I've got a similar question. In my case I linked an Oracle database to my
SQL Server 2005 Standard database. I also want to see the tables in the
linked server. I hope someone can answer this for both of us...

Randall Arnold

[quoted text, click to view]