devxlogo

Linking SQL Server to Informix

Linking SQL Server to Informix

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

See also  5 Strategies for Supercharging Your CRM
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist