run-time error '3669'

[angie]

I am getting run-time error "'3669' - execution cancelled" on the following open statement - and can't find anything on '3669' or why it won't work. I tried the sql statement in oracle sql plus and it works fine, but not from VB. I also tried a single table select statement in the open and it worked too. Can anyone help?

Set rsGetAccount = cnRegister.OpenRecordset(m_strMainSelect & strWhereClause, dbOpenDynaset, 0, dbOptimisticValue)


** where m_strMainSelect = select * from aa, bb where aa.mun = bb.mun and aa.dist = bb.dist and aa.procdate = bb.prodate

** strWhereClause = and bb.Account = '13120046' and bb.Cust = '01' order by bb.ProDate;

[JR Ewing]

Don't know if you still need this

After the connection is made add the following line.

cnRegister.QueryTimeout = 0

This way it will wait until the recordset is retrieved.

http://msdn.microsoft.com/library/devprods/vs6/vbasic/dao360/daproquerytimeout.htm