SQL Linked Server to Informix connests but

Question

Hi,

I have created a linked server in SQL2008 which tests fine but when I use it e.g: -

select * from Openquery(Sentinel, 'Select * from Customer'

I get the following error: -

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "Ifxoledbc" for linked server "Sentinel" reported an error. The provider did not give any information about the error.

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider "Ifxoledbc" for linked server "Sentinel".

Answer 1

Hi FuzzyMI,

Ifxoledbc is a third party provider. Microsoft suggests to use official provider.

Please refer to:

http://msdn.microsoft.com/en-us/library/ms188279.aspx

If using the official provider, the problem still there, please follow this thread to solve this issue:

http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/8514b4bb-945a-423b-98fe-a4ec4d7366ea

---

Iric Wen
TechNet Community Support