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
procedure.

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

AS

NULL
 BEGIN

 END

GO

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?

Eric