Microsoft error 7399 and 7330 running query within SQLServer
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.
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:
Link describing comparisons between Process and Out of Process:
More support for:
Informix Client Software Development Kit (CSDK)
Software version: 3.5, 3.7, 4.0
Operating system(s): Windows
Reference #: 1427734
Modified date: 30 July 2010