RDO 1 -> RDO 2 Problem

RDO 1 -> RDO 2 Problem

Post by Peter Mars » Thu, 25 Sep 1997 04:00:00



Using VB 4 and SQL 6, the following code runs fine.  It does not
work under VB 5 sp2 and SQL 6.5 sp3.  It is calling sp's on the
server, but returns the error:

Method 'StillExecuting' of object _rdoResultset' failed.

What is new with RDO 2 that is killing this code?

    Set en = rdoEngine.rdoEnvironments(0)
    rdoErrors.Clear
    '
    conn = "DSN=ta;UID=" + userid + ";PWD=" + password + ";DATADASE=ta;"
    Set cn = en.OpenConnection(dsname:="", _
                                Prompt:=rdDriverNoPrompt, _
                                ReadOnly:=True, _
                                Connect:=conn)
    Set rs = cn.OpenResultset(Name:=SQL, _
                                Type:=rdOpenForwardOnly, _
                                LockType:=rdConcurReadOnly, _
                                Options:=rdAsyncEnable)
    While rs.StillExecuting
        If frmVbfilm.PBar.Value = 1000 Then
            frmVbfilm.PBar.Value = 0
        End If
        frmVbfilm.PBar.Value = frmVbfilm.PBar.Value + 1
        DoEvents
    Wend