Missing SqlDataReader

Just doing some experimenting with Webservices and I seem to have run into a snag. <br><div class="msgQuoteWrap"><div class="msgCode"><br> Dim dr As SqlDataReader = oHours.FetchTOEmpHoursMax(sEmp, oCnn)<br> While dr.Read<br> mxSick = dr("sicktime")<br> mxVac = dr("vacationtime")<br> End While<br></div></div><br>for some reason, my dr is coming back as nothing. here's the FetchTOEmpHoursMax code<br><div class="msgQuoteWrap"><div class="msgCode"><br> Public Function FetchTOEmpHoursMax(ByVal sEmp As String, ByVal oCnn As SqlConnection) As SqlDataReader<br> Dim sPArray(0) As SqlParameter<br> Try<br> sPArray(0) = New SqlParameter("@emp", sEmp)<br> FetchTOEmpHoursMax = SqlHelper.ExecuteReader(oCnn.ConnectionString, CommandType.StoredProcedure, "Fetch_Emp_HoursMax", sPArray)<br> Catch ex As Exception<br> ExceptionManager.Publish(ex)<br> Throw ex<br> End Try<br> End Function<br></div></div><br><br>I know my sproc is ok, as i've tested in and it works. In fact this function has been cut and pasted from another page that works fine. Yet for some reason this function only returns nothing. Anybody got any ideas? <img border="0" src="/forum/emoticons/sad.gif" height="15" width="15" alt="sad" />

It's amazing, apparently I still managed to copy the storedproc name incorrectly. <br>I've been staring at this too long, time for a break.