All HROWs must be released

All HROWs must be released

Post by Ed Barne » Mon, 06 Mar 2000 04:00:00



I got the following error message in an application that I'm converting from
using DAO to use ADO. What does this mean and what do I do about it.

"-2147217883 All HROWs must be released before new ones can be obtained"

The routine is attempting to set and index in preparation for doing a Seek.

 
 
 

All HROWs must be released

Post by Hansom » Fri, 17 Mar 2000 04:00:00


I was getting this error, too.  My problem was that I was SELECTing a
hard-coded empty string ('').  When I modified my query to return a
space (' ') instead, the error went away.

Hope I helped,
Jason



> I got the following error message in an application that I'm
converting from
> using DAO to use ADO. What does this mean and what do I do about it.

> "-2147217883 All HROWs must be released before new ones can be
obtained"

> The routine is attempting to set and index in preparation for doing a
Seek.

--
"The problem is not whether computers think,
but whether men do." -- Unknown

Sent via Deja.com http://www.deja.com/
Before you buy.