Groups | Blog | Home
all groups > sql server odbc > february 2004 >

sql server odbc : ODBC to linked server



Doug Guerena
2/17/2004 2:31:08 PM
Frederick G. Pierz
2/17/2004 2:32:02 PM
I have created a linked server using an OLE DB service in a SQL Server 2000
database running on Windows NT 4.

I can see all the tables and views of the linked server in Enterprise
manager, but when I go to a client machine and try to setup a DSN to the
linked server using an SQL Server driver all I can see for a default
database is the example Microsoft databases (Northwind, Pub, etc.). How do I
get the ODBC driver to use the linked server as a default database?

Any help would be greatly appreciated.

AddThis Social Bookmark Button