problem with query inside asp code

i have a query that runs fine in oracle, but when i try and run it through my code i get an error :
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation

/test/WO_Metrics.asp, line 129

i know that it has to do with the way my query is coded, i think maybe with the nested query. because it worked fine before i put the nested query in. is there a special way to handle nested queries in aps?

here's the oracle code:

select distinct t.tsnumb, wo.woseqn, wob.wcbask, wob.wcstat, wob.wcdate from tsr t, workorder wo, wobaskdtl wob
where wo.woseqn in
(select distinct wob2.wcseqn from wobaskdtl wob2)
and t.tsstat='C'
and t.tsnumb=wo.wonumb
and t.tsnumb=wob.wcnumb
and wo.woseqn=wob.wcseqn
and wo.wostat='C'
and wo.wonumb='00050056'
order by t.tsnumb, wo.woseqn


asp code:

StrSQL = "Select Distinct T.TSNUMB, WO.WOSEQN, WOB.WCBASK, WOB.WCSTAT, WOB.WCDATE from TSR T, WorkOrder WO, WOBaskDtl WOB where WO.WOSEQN IN (Select distinct WOB2.WCSEQN from WOBaskDtl WOB2) and T.TSSTAT='C' and T.TSNUMB=WO.WONUMB and T.TSNUMB=WOB.WCNUMB and WO.WOSEQN=WOB.WCSEQN and WO.WOSTAT='C'and WO.WONUMB='00050056' order by T.TSNUMB, WO.WOSEQN"

You didnn't say which version of oracle you are using, but http://www.cryer.co.uk/brian/oracle/ORA01013.htm has a couple possible things to do with that error. It sounds like that error could mean your request is timing out. Are you sure your connection to the database is actually working?