IBM Support

Microsoft error 7399 and 7330 running query within SQLServer

Technote (troubleshooting)


Problem(Abstract)

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

How to define a Microsoft® SQL Server linked server to

Document information

More support for: Informix Tools
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