Row handles must all be released before new ones can be obtained.

  • I hope someone can help me here! 🙂

    I have a scenario where we need to query (using openquery through a linked server connection) data from a pervasive 9.5 database from SQL2005 and we get the following error:

    "Row handles must all be released before new ones can be obtained."

    I have latest SPs applied for both SQL2005 and Pervasive. I can't even nail it down to x number of records or data types or number of columns - it all varies from table to table. This is all on a "brand new" install, new server and apps.

    Thanks for any help!

  • What else is running that could 'grab' row handles? At what point in your processing are you getting this message? Do you believe this message is legitimate or a proxy for some other problem? Have you had this working ever, or is this your first attempt to do this?

    Any additional context information you can provide could prove useful.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply