ODBC Data Source to a linked SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

listrecv@gmail.com - 22 Jan 2006 14:29 GMT

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?

Reply to this Message

Randall Arnold - 31 Jan 2006 14:29 GMT

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

> I'd like to set up an ODBC Data Source to a table in a linked SQL
> Server, via
[quoted text clipped - 8 lines]
> How can I create an ODBC Data Source which uses a database in the
> linked server as its default database?

Reply to this Message