SQLSTATE=24501 in a query on a linked server.

[is47501]

Hi all,

I am receiving this error

"SQL0501N The cursor specified in a FETCH or CLOSE statement is not open. SQLSTATE=24501"

when running a query against a linked server in Sql Server 7.0. The linked server is an UDB (DB2) database linked with the OLE DB provider for ODBC. I do not get this error on every table I attempt to query.

Any ideas on how to correct this problem?

 

[is47501]

I found that an OPENQUERY(DW,'SELECT...') worked.