i am not sure what you are asking,
just see this minimum requirements for sqlserver 2008

it think, actually the problem is single quote
since he just concatenate the string to build the query, if the end user type the string value Supplier's Data in one of the textbox it should raise this error
you should solve this by using parameterized query like already suggest you
i hope now you know how the problem raised?
Happy coding

well seems some sort of long running loop is the problem,
i have a suggestion to you instead of raising a event why don't you create a public variable for that class that to verify the current message is read or not, this will avoid a some sort of problems for me while using a MSCOMM
so here is my idea
ok i will give little sample here

public blnReadCompleted as Boolean
Public Sub subRead(ByVal lngIndex As Long, ByVal strData As String)
On Error GoTo ErrHandler

    'let the server carry on with its business
    'and let the timer event trigger the data processing
    mlngIndex = lngIndex
    strDataToProcess = strData
    
    'Raise the event here to avoid delays
    'RaiseEvent DoneRead
     blnReadCompleted =True
    
    tmrProcessData.Interval = cstProcessDataTimerInterval
    tmrProcessData.Enabled = True

ExitHandler:
    Exit Sub
ErrHandler:
    fintClientError Err.Source, "subRead " & Err.Description, Err.Number
End Sub

chage your while loop like this

    objSession1.blnReadCompleted = False
    While (objSession1.blnReadCompleted = False) And (blnSendTimeout(1) = False)
        If blnTryOnce = True Then
            'try to send to session exe
            objSession1.subRead 1, strData
            blnTryOnce = False
        End If
        DoEvents
    Wend

in the same manner you can also remove the timer also,
now the code is as straight as it would be, so you can get the control over the server from your client
this is only my suggestion well tell me whether this will lead a path to solve your problem or not

lstItem.text =rs!strProcStep & ""

will be enough

can you please explain the problem briefly