Question:
Can I set up a live ODBC link from SQL Server 7 to an Informix (Standard Engine) database?
Answer:
You can set up your Informix server as a linked server. SQL Server provides the ability to link to any OLE DB data source as a linked server. You’ll probably have to use the OLE DB data provider for ODBC and have a valid DSN pointing to your Informix database.
Once you’ve linked the server, you can access it with a distributed query just like any other server. Here’s an example of a distributed query from the SQL Server BOl that accesses data from an Employee table in SQL Server and an Orders table in Oracle:
SELECT emp.EmloyeeID, ord.OrderID, ord.DiscountFROM SQLServer1.Northwind.dbo.Employees AS emp,OracleSvr.Catalog1.SchemaX.Orders AS ordWHERE ord.EmployeeID = emp.EmployeeIDAND ord.Discount > 0