Error: row handle is invalid

[Beat-Down]

I have a segment of code that works most of the time but every once in a while I get this error.

 

row handle is invalid

 

My code looks like this (Except its cleaned up)

 

cmFax.CommandText = "SELECT FaxNumber..."

drFax = cmFax.ExecuteReader

drFax.Read()

 

//drFax Reads 6 items from 0 to 5

//THIS IS WHERE THE ERROR OCCURS (Works 99% of the time)

If drFax.IsDBNull(5) Then

 

sServerOutput(3) += 1

 

Else

 

cm.CommandText = "INSERT INTO ...."

cm.ExecuteNonQuery()

sServerOutput(0) += 1

sLastFile = sTempFileName

sLastFileTime = Now.TimeOfDay.ToString

 

 

End If:mad: :mad: