RE: Informix and SQL Server

sqlserver has something called as "linked servers" where you can connect to other database servers using odbc data sources, you can then run distributed queries from sqlserver. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of Martin Fuerderer Sent: Tuesday, February 15, 2005 2:57 AM To: William Weaver Cc: informix-list@iiug.org; owner-informix-list@iiug.org Subject: RE: Informix and SQL Server Hi, there's "Informix Enterprise Gateway Manager" (as others have already suggested), but as far as I remember, it provides to Informix (server or applications) access to other databases, but not the other way round. I.e. it cannot let SQL Server make a connection to IDS. At least my understanding of it. For more info check out http://www.ibm.com/software/data/informix/tools/egm/ Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 14.02.2005 22:41:43: > Nobody seems to want this one! Please, if anyone can help I would really appreciate it! > > Thanks! > > Bill Weaver > Director of Engineering > Amicus, Inc. > 512-531-3463 (office) > 512-531-3401 (fax) > -----Original Message----- > From: William Weaver [mailto:wweaver@amicus.com] > Sent: Thursday, February 10, 2005 4:03 PM > To: 'informix-list@iiug.org' > Subject: Informix and SQL Server > > > It?s been a while since I?ve been in the Informix world (sigh) as I?ve been working lately > with a Sybase database (yuck!) so I need some help getting back into things with Informix. > > I have a client who needs to connect a Microsoft SQL Server database to an Informix database. > What is the best driver for this in terms of both speed and data type conversion? > Of special concern is Informix date variables to SQL Server native datetime. > > Thanks! > > Bill Weaver > Director of Engineering > Amicus, Inc. > 512-531-3463 (office) > 512-531-3401 (fax) sending to informix-list sending to informix-list