Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQLDatadapter Timeout Expired Error

Author  Topic 

dipb
Starting Member

2 Posts

Posted - 2004-04-19 : 05:43:05
Hi,

We are using SQLDatadapter for retrieving the data from the SQL Server 2000. We are using .NET Framework 1.0.3705. Immediately on accessing the FILL method to populate the dataset, it throws a "Timeout Expired......." exception.

Do anybody here have any idea about why this is happening. If so pls help me in fixing this problem.

Thanks,
dips

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-04-19 : 05:52:56
dips, do you always get this error or only when you are trying to load large datasets? There has to be a limitation on the maximum number of records that can be loaded before the query times out. You could try limiting the number of records returned by the query.

OS
Go to Top of Page
   

- Advertisement -