Why am I getting a Closed Recordset 
Author Message
 Why am I getting a Closed Recordset

I am having a problem where I have am returning a disconnected recordset
that is created from a Stored Procedure.  Here is the basis of the stored

CREATE  PROCEDURE usp_InsertMimeType
--   Test to find a entry for the passed mime type





When I try to access the EOF or BOF properties of the disconnected recordset
it is saying that I can't do this because it is closed.  Why is this closed?
When I run this from query analyzer it returns a recordset.  I am thinking
the problem is somewhere with transactions.  Anyone have any thoughts?


Wed, 15 Sep 2004 00:08:49 GMT  
 [ 1 post ] 

 Relevant Pages 

1. why am I getting this error??

2. Why am I getting this message?

3. Null Values - WHY am I getting this error?

4. Please Help: Why am I now getting this error

5. Why am I getting this error ?

6. ADO Recordset disappers when sql_conn closed - why?

7. Does ADO Connection.Close ,Closes all open Recordsets

8. When closing a connection, recordset is also closed!

9. New Recordset and Closed Recordset

10. Set Recordset to Nothing vs Recordset.close

11. recordset.close vs. set recordset=nothing

12. Set Recordset = Nothing or Recordset.close


Powered by phpBB® Forum Software