Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Tableadapter timeout

Thread Tools

Tableadapter timeout
Posts: n/a
I have a dataset that is filled by a sp in SQL2005. The sp results can
be 1 - 100 records. Depending on the parameters. The execution time
can take up to 2 min. Depending on the parameters. The data is used in
a web report in vs2005.

The problem is if the sp executes les than 30 seconds, I get results.
As soon as the time exceeds 30 seconds. I get the time out error.

I have added "connection timeout=600" in the connection string. But
it keeps on timing out on 30 seconds.

Can any one help me, where can I set the timeout property for a
Tableadapter/Dataset/Datatable/ObjectDatasource in vs2005, web

Thanks in advance

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
vs2005 - How to fill form using TableAdapter FillBy dbuchanan ASP .Net 0 12-13-2005 12:43 AM
VS2005 - Newbie - TableAdapter not configured, but it updates!! dbuchanan ASP .Net 0 12-12-2005 10:41 PM
TableAdapter differ with win and web application. ad ASP .Net 0 12-01-2005 09:04 PM
VS2005 - How to connect to a TableAdapter in the data layer dbuchanan ASP .Net 3 12-01-2005 01:28 PM
Timeout::timeout and Socket timeout Mark Probert Ruby 1 10-06-2004 09:30 AM