Reason why .asp code works on one server but not another

We have a .asp website (9000+ files) that was on 2000 server (and 2000 MS SQL database) an have since moved it to a 2003 server with a 2005 SQL server and now some of the site does not work.  We keep getting the following errror:
ADODB.Command error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/manager/ssi/i_get_prod_entity_name.asp, line 24

and here is that code from the i_get_prod_entity_name.asp

<%
REM Function gets name of product entity
Function GetName(strAssocType, intAssocObjId)
      Select case strAssocType
            case "pf_id"
                  strText = "product family"
                  strStoredProc = "prod_family_select_by_pf_id"
                  strRS = "pf_name"
            case "pd_id"
                  strText = "product department"
                  strStoredProc = "prod_dept_select_by_pd_id"
                  strRS = "pd_name"
            case "prod_id"
                  strText = "product"
                  strStoredProc = "prod_select_name_by_prod_id"
                  strRS = "prod_name"
      end select

      CreateDBConnection()
            ConnectionObject.BeginTrans
            CommandObject.CommandType = 4 'adCommandObjectStoredProc
            CommandObject.CommandText = strStoredProc
            'CommandObject.Parameters.Refres
            CommandObject(1) = intAssocObjId
            set rsName = CommandObject.Execute()
      CloseDBConnection()
      If not rsName.eof then
            strRS = rsName(strRS)
            GetName = array(strText, strRS)
      else
            GetName = null
      end if
End Function
%>

I have checked the 2005 SQL database and it does have all the same stored procedures as the 2000 server.  Please help.  This is pretty important.
View the Solution FREE for 7 Days