Hi All...

We are using ASP and Sybase in our application,We are using ADOs to connect to the DB. The issue is, query is fetching partial data from the DB.(this we found when comapred output with executed same query at the sql prompt). But it is not hapening all the times. If the query which is taking more time (say more than 4-5 minutes) it is giving partial result set instead of giving timeout or some error. How to handle this problem??? It will be fine if we can increase the timeout property (if any) or else atleast i want to trap an error instead of ending up fetching partial data.

Thanks in advance..

Regards,
gamini

You can use the TimeOut property to increase the runtime:
Syntax:

<% Server.ScriptTimeout = 100 %>

with 100 being the number of seconds