Sql server remote server returned an error: Not found

yes, all the queries are run by the same connection string but i am executing only one stored procedure at a time and not all the stored procedures together...


<operationcontract()> Private Function fnStoreProcedureGetDataSet(ByVal strQry As String, ByVal strpara As String) As List(Of SearchData)
Try
retScon.ConnectionString = settings.ConnectionString
retScmd.CommandText = strQry
If strpara.Trim.Length > 0 Then
Dim strPar() As String = Split(strpara, "!@!") // The parameters are concatenated with !@! and later split to individual parameters.
For intcount = 0 To strPar.Length - 1
retScmd.Parameters.AddWithValue(strPar(intcount).Split("|").ElementAt(0), strPar(intcount).Split("|").ElementAt(1))
Next
End If
retScmd.CommandType = CommandType.StoredProcedure
retScmd.Connection = retScon
sadaDapt.SelectCommand = retScmd
sadaDapt.Fill(datsData)
retScon.Close()
Dim IntClnCnt As Integer = 0
Dim StrColumnName As String = String.Empty
For IntClnCnt = 0 To datsData.Tables(0).Columns.Count - 1
If StrColumnName = String.Empty Then
StrColumnName = datsData.Tables(0).Columns(IntClnCnt).ColumnName
Else
StrColumnName = StrColumnName & "," & datsData.Tables(0).Columns(IntClnCnt).ColumnName
End If
Next
Dim clsRpts As New ClsCommonRpt
Return clsRpts.fnGetLargeReportData(datsData)
Catch ex As Exception
Return Nothing
End Try
End Function

yes it is and the number of rows fetched is also significantly large...
but there are other procedures with large output and which takes more than 15sec to execute but they work well.. cannot understand whats happening in this case..
is there any specific issue??