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.