I have an intranet application that is calling a webservice (code below). The webservice calls a stored procedure in q sql server 2005 that again does an openquery on a db2 (AS400) machine. The stored procedure is returning a temp table.
On the call to the webservice I am getting a time out. At this point if time out the web service is still running and I can also see the query is in the program stack on the db2 machine. The query itself can take up to 20-30 minutes as it is reading 3 mill+ records. If I call the web service directly I get the result returned.
Is there a timeout setting I need to look at or any other suggestion? Thank you.
Dim getOrderDetail As New localhost.OrderDetail
myDataTable = getOrderDetail.GetOrderDetailRecords_DataTable(myUserId)