Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Lightbulb Unanswered: how to use SQLSetConnectOption API with RDO

    I am facing problem while opeining recodset with SP with Sybase database
    Its cursor gets closed on server itself and I get Error
    Run-time error '40088':
    No open cursor or cursor closed.

    Can anybody tell me how to solve this problem or how to use this API
    to resolve issue Code is somewhat like this

    Set nNode = tvw.Nodes.Add gives error Pls help me out ! and I will be really thankful to u!

    Public Function PopulateContactTree(bExpand As Boolean, _
    cmdExpand As Control, _
    tvw As Control, _
    sTable As String, _
    nSchemeAdvisor As Integer, _
    nSchemeAdvisorId As Long)


    Dim nNode As Node

    Set nNode = tvw.Nodes.Add(, , "Location" & Str(rs!LocationId), _
    rs!Address1 & " " & IIf(IsNull(rs!Address2), " ", rs!Address2) & " " & rs!Town & " " & rs!County & " " & rs!Postcode & " " & IIf(IsNull(rs!LocationPhone), " ", rs!LocationPhone))

    Any Help will be higly appreciatecd!

  2. #2
    Join Date
    Jun 2003
    Posts
    140

    Re: how to use SQLSetConnectOption API with RDO


Posting Permissions

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