Re: making datareaders

ok i am looking through the factory methods; i've been looking into
that for a while now

but i just swear; it is something much much simpler

I rewrote it so that i dont have to deal with the 'getDataReader'
procedure
but still i get the same error:
----------------------------------

There is already an open DataReader associated with this command which
must be closed first.
----------------------------------

This is my first ADO.net conversion and i'm just kinda banging my head
against a wall.

From what i understand; this is like a 2003 bug and it's fixed by
MARS-- multiple active result sets.

Right??

I know that the connection works; i've tested it with commands and it
works like a charm.


Dim cmd As System.Data.SqlClient.SqlCommand = cnnX.CreateCommand()
cmd.CommandText = "EXEC spRootFoldersToCatalog"
Dim DR As System.Data.SqlClient.SqlDataReader = cmd.ExecuteReader

While DR.Read
RootFolder = DR.GetValue(1).ToString
rootFolderID = CInt(DR.GetValue(0).ToString)
Call RootFolder_Catalog(RootFolder, rootFolderID)
End While

.