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!