Results 1 to 4 of 4

Thread: Run-time error 40088, 40008

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2007
    Posts
    5

    Run-time error 40088, 40008

    Hi
    I am using RDO connection to get data from sybase 12.5. In VB 6.0 my code goes like this:

    Code:
    Dim cn As New rdoConnection
    Dim rdoRS As rdoResultset
    Dim rs, rs1 As rdoResultset
    
    cn.Connect = "uid=R64037;pwd=***;server=TEST_SERVER;" _
        & "driver={SYBASE ASE ODBC Driver};NA=test.com,4500;database=test_database;" _
        & "DSN=test_dsn;"
        cn.CursorDriver = rdUseOdbc
    cn.EstablishConnection rdDriverNoPrompt
    
    SQL = "exec JP_FIND_STRING " & "'" & Text1.Text & "'"
    Set rdoRS = cn.OpenResultset(SQL)
    While Not rdoRS.EOF
        List1.AddItem (rdoRS.rdoColumns(0).Value)
    rdoRS.MoveNext
    Wend


    While Executing the above code, I am getting the run-time error
    40088 - No open Cursor or Cursor Closed (I am getting this always)
    40008 - Invalid operation for forward only cursor (i am getting this occassionally)

    Kindly suggest me the solution
    Thanks in Advance
    Regards,
    J.Hari
    Last edited by si_the_geek; Apr 14th, 2007 at 10:30 AM. Reason: added code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width