Linked server informix in sql server

Discussion:

(too old to reply)

r***@gmail.com

2007-09-28 12:09:04 UTC

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

Premnath Srinivasan

2007-09-28 12:21:38 UTC

Permalink

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

***@gmai
l.com
Sent by: To
informix-list-bou informix-***@iiug.org
***@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

r***@gmail.com

2007-09-28 12:45:22 UTC

Permalink

Post by Premnath Srinivasan
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
l.com
Sent by: To
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
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

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.

DL Redden

2007-09-28 14:00:30 UTC

Permalink

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: "***@gmail.com" <***@gmail.com>
To: informix-***@iiug.org
Sent: Friday, September 28, 2007 7:45:22 AM
Subject: Re: Linked server informix in sql server