Re: Informix connection to SQL Server
surely ODBC will work ? Unless of course the ODBC stuff doesn't ship with IDS on Linux Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 GO FURTHER with DB2 GET THERE FASTER with Informix. Attend the IDUG 2006 North America Conference. Tampa, Florida, USA. 7-11 May 2006. Visit http://www.iiug.org/conf for more information. From: Sathyanesh Krishnan [mailto:satyan@us.ibm.com] Posted At: Wednesday, March 08, 2006 3:08 PM Posted To: comp.databases.informix Conversation: Informix connection to SQL Server Subject: Re: Informix connection to SQL Server Hi Eduardo, By default there is no facility exist that you can directly connect from Informix Server to SQL server without help of UDR (that you may have to come up). If you are asking how to access Informix Database from SQL Server then use "the linked server concept". You may find linked server configuration information from MSDN. Regards, Satyan Software Engineer R&D - IBM Information Management Division 11200 Lakeview, Lenexa, KS 66219 Tel: 913 599 8792 (T/L: 337-8792) Inactive hide details for cboccio@yahoo.com.brcboccio@yahoo.com.br cboccio@yahoo.com.br Sent by: informix-list-bounces@iiug.org 03/08/2006 02:43 PM To informix-list@iiug.org cc Subject Informix connection to SQL Server Hi all, Does anyone knows how to connect a SQL Server from an Informix Database installed on a Linux machine ? Tks, Regards, Eduardo _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
On Thu, 2006-03-09 at 12:15 -0600, Paul Watson wrote: > surely ODBC will work ? Unless of course the ODBC stuff doesn't ship > with IDS on Linux It does, and it works fairly well.
I have a similar question regarding database access from Linux to MS systems. Can Informix "serve" up data from other DBMS's as if they were native tables? Similar to the "linked server" concept in SQL Server. This is where you define an ODBC/OLE DB connection at the Informix database level to another database engine - the data from that engine then appears as native tables within the Informix database. I'm trying to flesh out what connection/data access options we have integrating data with an Informix instance running on Linux and another database engine running on a windows platform (most likely SQL Server 2005). Maybe a stupid question altogether - does OLE DB even exist in the Linux world? Thanks. -- William Fields Code Contortionist MCSD - Microsoft Visual FoxPro US Bankruptcy Court Phoenix, AZ ".dll hell - .rpm hell - whatever. The grass is always greener" "Adam Tauno Williams" <adam@morrison-ind.com> wrote in message news:mailman.56.1141933614.18205.informix-list@iiug.org...