This part is on the ASP page and calls the function Get Data
Set rs = Server.CreateObject("ADODB.Recordset"

Set rs= GetData(iOrgID, iAccountID)
This is the function:
'*********************************************************************
Function GetData(ByVal iOrgID, ByVal iAccountID)
Dim cmdGetData
Dim dbConnection
Dim rs
'Set the Connection string
Set dbConnection= CreateObject("ADODB.Connection"

Set cmdGetData= CreateObject("ADODB.Command"

Set rs = CreateObject("ADODB.Recordset"

dbConnection.Open sConnString
With cmdGetData
.CommandType = adCmdStoredProc
Set .ActiveConnection = dbConnection
.CommandText = "sp_GetData"
.Parameters.Append .CreateParameter("@OrgID", adInteger, adParamInput, ,iOrgID)
.Parameters.Append .CreateParameter("@AccountID", adInteger, adParamInput, ,iAccountID)
Set rs = .Execute
End With
Set GetData = rs
Set cmdGetData = Nothing
Set dbConnection = Nothing
End Function
Then once the recordset is pulled into the ASP page, I am trying to use it more than once...so I scroll through it the first time, and the do a .MoveFirst so it starts at the top of the recordset...this is where I'm getting the error.
Any advice would be greatly appreciated. I've tried setting CursorType, CursorLocation, and LockType to see if I get it to work without much success. Rowset sounds like it is something coming from SQL Server.
Thanks in advance.