Oninit cdi / Archive
Talk to an expert →

Re: Linked server informix in sql server

Posted in 2007

DL Redden — — source: Usenet: comp.databases.informix

Keep in mind that linked server operates in the same way a distributed query works in Informix. If using OPENQUERY, which is the only way I've been able to utilize a linked server to Informix the entire result set of the query executed by OPENQUERY is returned to SQL Server before the results can be used as a table. Put filters in the OPENQUERY call when possible to limit the data returned from Informix. ----- Original Message ---- From: "rortiguela06@gmail.com" <rortiguela06@gmail.com> To: informix-list@iiug.org Sent: Friday, September 28, 2007 7:45:22 AM Subject: Re: Linked server informix in sql server On 28 sep, 14:21, Premnath Srinivasan <s.premn...@in.ibm.com> wrote: > Hi, > > Against which database did you run the coledbp.sql file ? This SQL file > should be run in SYSMASTER database. > > And what is this error ? Please translate that to English. > Error 7399: El proveedor OLE DB 'Ifxoledbc' informa de un error. > Elproveedor no proporcionó información acerca del error. > > Regards, > Premnath Srinivasan > > rortiguela06@gmai > l.com > Sent by: To > informix-list-bou informix-l...@iiug.org > n...@iiug.org cc > > Subject > 28/09/2007 17:39 Linked server informix in sql > server > > hello, > Sorry for my English, is very poor. > I have a problem when try to link a server informix in sql server. I > have this linked server for ODBC, but the speed is bad. Then i want to > link the server with OLEDB, i have installed "IBM Informix Client-SDK > 3.00" and "IBM Informix Connect 2.90" and in the informix server run > the script "coledbp.sql", but when connect by OLEDB the error is: > > Error 7399: El proveedor OLE DB 'Ifxoledbc' informa de un error. El > proveedor no proporcionó información acerca del error. > > Please, help me > Thank you very much > > _______________________________________________ > Informix-list mailing list > Informix-l...@iiug.orghttp://www.iiug.org/mailman/listinfo/informix-list Thank's Yes, run the "coledbp.sql" in sysmaster. And sorry for the message, this is the translate: Msg 7399, The OLE DB provider "Ifxoledbc" reported an error. The provider did not give any information about the error. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list