RE: Informix and SQL Server
I dug in the SQLserver help, and found the below on 'linked servers'. Accessing External Data To access data from an OLE DB data source, provide Microsoft(r) SQL Server(tm) 2000 with the following information: The name of the OLE DB provider that exposes the data source. Any information the OLE DB provider needs to locate the source of the data. Either the name of an object that the OLE DB data source can expose as a rowset, or a query that can be sent to the OLE DB provider that will cause it to expose a rowset. The objects that can be exposed as rowsets are known as remote tables. The queries that generate rowsets are known as pass-through queries. Optionally, you can supply SQL Server with valid login IDs for the OLE DB data source. SQL Server 2000 supports these methods for referencing heterogeneous OLE DB data sources in Transact-SQL statements: the linked server name and the ad hoc computer name. Linked Server Names A linked server is a virtual server that has been defined to Microsoft(r) SQL Server(tm) 2000 with all the information needed to access an OLE DB data source. A linked server name is defined using the sp_addlinkedserver system stored procedure. The linked server definition contains all the information needed to locate the OLE DB data source. Local SQL Server logins are then mapped to logins in the linked server using sp_addlinkedsrvlogin. Remote tables can then be referenced by using the linked server name: As the server name in a four-part name used as a table or view reference in a Transact-SQL statement. The other three parts of the name reference an object in the linked server that is exposed as a rowset. As an input parameter to an OPENQUERY function. OPENQUERY sends the OLE DB provider a command to execute. The returned rowset can then be used as a table or view reference in a Transact-SQL statement. -----Original Message----- From: Sebastian, Norma J. Sent: Tuesday, February 15, 2005 4:24 PM To: 'Savio Pinto (s)'; William Weaver Cc: informix-list@iiug.org; owner-informix-list@iiug.org Subject: RE: Informix and SQL Server Tell me more about this 'linked server' stuff. We have oracle, informix, and sqlserver. I am trying to set up a scenario to help Bill without him having to buy another tool. I created a Sqlserver DTS to dump some oracle data from a unix oracle db to my PC. I was thinking Bill could create a job on the informix side to dump whatever data is needed to a file, then use DTS to ftp the file somewhere in the sqlserver domain, and have sqlserver DTS the dump file in and manipulate it accordingly. But if linked servers could do the trick... Please explain a bit further and I will test here. Thanks, Norma Jean -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Savio Pinto (s) Sent: Tuesday, February 15, 2005 10:02 AM To: William Weaver Cc: informix-list@iiug.org; owner-informix-list@iiug.org Subject: 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 ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================ sending to informix-list