Problem with using table adapters with datasets

  • Thread starter Thread starter TheVillageCodingIdiot
  • Start date Start date
T

TheVillageCodingIdiot

I have a dataset in a asp.net 2.0 web page. In there there are three
table adapters and datatables calling different sprocs. The web/sql
server is a windows 2003 running iis6 with sql server 2005 enterprise
edition. Im having a problem deploying this new webpage out to the
server. When I run the webpage from my pc it works perfect, but when I
move it up to the webserver, I keep getting SQL timeout errors when it
calls the tableadapter.fill method. the store proceedure only takes
like 200ms to run. anyone have any ideas.
 
Here is some more info. I noticed on the SQL activity monitor, the sql
command is suspended and under the wait type column it says
ASYNC_NETWROK_IO and it never executes. Any ideas?
 
Back
Top