Link Servers - MS SQLServer/Informix

Posted in 1999

Denis Hung — Tue, 1 Jun 1999 20:29:38 +0400 — source: Informix-list mailing list archive (1991-1998)

Hi: We have a multitude of database servers in our company: SQL Base, SQL Server, Informix and Access. What I want to do is connect all those on my MS SQL Server 7.0 through ODBC. I have created the linked servers and followed the instructions for distributed queries. I can created the link server and can see the tables as well, but the problem is that I cannot query them. I have used the syntax: Linkserver.dsnname..tablename I cannot understand what the catalog field in the link server is for. Can somebody help me out with this? Thanks.