Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004

    Unanswered: need help with timeout problem

    hi all,

    the following code times-out the first couple of times, but then starts to
    work (if u can call 20 second queries "working"). this happens everytime
    someone runs this code for the first time.

    mConn.ConnectionString = "PROVIDER=MSDASQL;DSN=MyDsn"
    mConn.CursorLocation = adUseServer
    mConn.ConnectionTimeout = 0

    mSQL = "select distinct tixhistlin.ItemNumber,tixhistlin.ticketnumber, " & _
    "From tixhistlin, tixhisthdr " & _
    "where tixhistlin.customernumber='" & Me.txtCiPhHome.Text & "'"

    mRsTixHist.Open mSQL, mConn, adOpenForwardOnly, adLockOptimistic
    that plus the fact that no matter what i set the timeout value to, the
    operation still times out after 30 seconds (the default?)

    this has me perplexed...
    (any more perplexing and i'll be ready for a straight-jacket)

    any suggestions are appreciated...

  2. #2
    Join Date
    Oct 2004
    plz overlook the query statement, i didn't copy & paste it too well...

  3. #3
    Join Date
    Dec 2001
    Provided Answers: 6
    What version of Pervasive are you using? How long does the query take if you run it using the PCC?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

  4. #4
    Join Date
    Oct 2004
    version: 8

    PCC query duration: 10 seconds

Posting Permissions

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