Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002

    Thumbs up Unanswered: Partial Retrieval of Data

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


  2. #2
    Join Date
    Oct 2002
    You can use the TimeOut property to increase the runtime:

    <% Server.ScriptTimeout = 100 %>

    with 100 being the number of seconds

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts