ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Using the SQL Server 2000 Reporting Services
Subject:   Trying to export large report to excel.
Date:   2008-06-10 03:41:16
From:   Ritish Dhir
Response to: Trying to export large report to excel.

Hi wherever you are setting command.
Use Sqlcommand.Timeout=600;(at your choice 600 equvalent to 10 minutes.By default in asp.net it is set as 30s..)


Thanks & regards
Rocky