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
[mailtowner-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