I have created a linked server in SQL2008 which tests fine but when I use it e.g: -
'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".
Ifxoledbc is a third party provider. Microsoft suggests to use official provider.
Please refer to:
If using the official provider, the problem still there, please follow this thread to solve this issue:
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?