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
mConn.Open

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...

plz overlook the query statement, i didn't copy & paste it too well...

What version of Pervasive are you using? How long does the query take if you run it using the PCC?

version: 8

PCC query duration: 10 seconds