Troubleshooting
Problem
When running a SQL statement within Microsoft SQLServer via a linked server and the IBM Informix OLEDB provider, one might encounter Microsoft error 7399 and 7330.
Symptom
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "ifxoledbc" for linked server "myserver" 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 "myserver".
Resolving The Problem
Changing the provider to run in process resolves the issue.
Here is a link describing the different provider options:
http://msdn.microsoft.com/en-us/library/ms188095.aspx
Link describing comparisons between Process and Out of Process:
http://msdn.microsoft.com/en-us/library/aa242100(VS.60).aspx
Related Information
Was this topic helpful?
Document Information
More support for:
Informix Tools
Software version:
3.5, 3.7, 4.0
Operating system(s):
Windows
Document number:
404831
Modified date:
20 January 2022
UID
swg21427734