Possible Resource Problems

[Rob Gray]

I am encountering a problem while retrieving data from an Oracle view, on occasions the recordcount will return 0 when there maybe more than forty records or so that meet the criteria, in other cases DAO does not like my sql statement even though it is valid.

this only seems to occur when im trying to retrieve larger quantities of records(not that large). but if im only attempting to retrieve a couple then it works fine.

the view that im trying to retrieve data from is actually quite complex, and it relies on inner joins with a hell of a lot of other tables, could this be the problem.


Any Suggestions.


[This message has been edited by Rob Gray (edited 09-28-1999).]

[JHausmann]

I'd be willing to bet that you're timing out when the view is trying to retrieve the data

I do not know if Oracle will let you do this but try setting the .ConnectionTimeout property to something like 600 (that's 10 minutes (600 seconds)).