Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
May 19, 2000

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.Discount
FROM SQLServer1.Northwind.dbo.Employees AS emp,
OracleSvr.Catalog1.SchemaX.Orders AS ord
WHERE ord.EmployeeID = emp.EmployeeID
AND ord.Discount > 0
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date