A transport-level error has occurred when sending the request to the server.

Hi,

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

I am using a direct connection from my Gridview to perform a huge database search. the stored procedure will take 10- 60 seconds to execute the query.

What the problem i am facing is when the sp takes long time (more than 1 minutes), then when i try any other operation like calling another sp frm another page, i am getting the above specified error.

Anybody can tell why is it happening?

here my code snippet goes

<asp:GridViewID="searchGV"runat="server"AllowPaging="True"AllowSorting="True"

BorderColor="#999999"BorderStyle="None"CellPadding="3"Width="100%"AutoGenerateColumns="False"DataSourceID="searchObj"DataKeyNames="Recordnumber"OnDataBound="searchGV_DataBound"OnPageIndexChanged="searchGV_PageIndexChanged">

<RowStyleCssClass="gridRow"/>

<PagerStyleHorizontalAlign="Center"BackColor="#999999"ForeColor="Black"/>

<HeaderStyleCssClass="gridHeader"/>

<AlternatingRowStyleCssClass="gridAlternateRow"/>

<Columns>

<asp:TemplateFieldHeaderText="All">

<HeaderTemplate>

<asp:CheckBoxID="chkid"AutoPostBack="true"OnCheckedChanged="OnCheckChangedEvent"runat="server"/>

</HeaderTemplate>

<EditItemTemplate>

<asp:CheckBoxID="chkSelect"runat="server"/>

</EditItemTemplate>

<ItemTemplate>

<asp:CheckBoxID="chkSelect"runat="server"/>

</ItemTemplate>

<ControlStyleHeight="18px"Width="15px"/>

<ItemStyleWidth="5px"/>

</asp:TemplateField>

<asp:BoundFieldDataField="Title"HeaderText="Title"SortExpression="Title">

<ItemStyleWidth="150px"/>

</asp:BoundField>

<asp:BoundFieldDataField="Artist"HeaderText="Artist(s)"SortExpression="Artist"/>

<asp:BoundFieldDataField="Album"HeaderText="Album"SortExpression="Album"/>

<asp:BoundFieldDataField="Writer"HeaderText="Writer(s)"SortExpression="Writer"><ItemStyleWidth="150px"/></asp:BoundField>

<asp:BoundFieldDataField="ISRC"HeaderText="ISRC"SortExpression="ISRC"/>

<asp:BoundFieldDataField="UPC"HeaderText="UPC"SortExpression="UPC"/>

<asp:BoundFieldDataField="PLineLabel"HeaderText="P-Line Label"SortExpression="PLineLabel"><ItemStyleWidth="100px"/></asp:BoundField>

<asp:BoundFieldDataField="DistLabel"HeaderText="Distribution Label"SortExpression="DistLabel">

<ItemStyleWidth="100px"/>

</asp:BoundField>

<asp:BoundFieldDataField="PublishInfo"HeaderText="Publisher(s)"SortExpression="PublishInfo"/>

<asp:BoundFieldDataField="Recordnumber"HeaderText="Record Number"SortExpression="Recordnumber"/>

<%-- <asp:BoundField DataField="UID" HeaderText="UID" Visible="false" />--%>

</Columns>

</asp:GridView>

with adapter

<asp:SqlDataSourceID="searchObj"runat="server"SelectCommand="gsp_titleSearchResult"SelectCommandType="StoredProcedure"ConnectionString="<%$ ConnectionStrings:ConnStr %>">

<SelectParameters>

<asp:ControlParameterControlID="HuserID"PropertyName="Value"Name="Userid"Type="String"Size="50"DefaultValue=""/>

<asp:ControlParameterControlID="Htitle"PropertyName="Value"Name="title"Type="String"Size="50"DefaultValue=" "/>

<asp:ControlParameterControlID="Hartist"PropertyName="Value"Name="artist"Type="String"Size="50"DefaultValue=" "/>

<asp:ControlParameterControlID="Halbum"PropertyName="Value"Name="album"Type="String"Size="50"DefaultValue=" "/>

<asp:ControlParameterControlID="Hwriter"PropertyName="Value"Name="writer"Type="String"Size="50"DefaultValue=" "/>

<asp:ControlParameterControlID="Hisrc"PropertyName="Value"Name="isrc"Type="String"Size="50"DefaultValue=" "/>

<asp:ControlParameterControlID="Hupc"PropertyName="Value"Name="upc"Type="String"Size="50"DefaultValue=" "/>

<asp:ControlParameterControlID="Hpline"PropertyName="Value"Name="pline"Type="String"Size="50"DefaultValue=" "/>

<asp:ControlParameterControlID="Hdist"PropertyName="Value"Name="distlabel"Type="String"Size="50"DefaultValue=" "/>

<asp:ControlParameterControlID="Hpublish"PropertyName="Value"Name="publisher"Type="String"Size="50"DefaultValue=" "/>

<asp:ControlParameterControlID="ReleaseID"PropertyName="Value"Name="Releaseid"Type="Int32"Size="50"DefaultValue="0"/>

<asp:ControlParameterControlID="RecordLabelID"PropertyName="Value"Name="recordlabelid"Type="Int32"Size="50"DefaultValue="0"/>

<asp:ControlParameterControlID="PublisherID"PropertyName="Value"Name="Publisherid"Type="Int32"Size="50"DefaultValue="0"/>

<asp:ControlParameterControlID="ArtistID"PropertyName="Value"Name="Artistid"Type="Int32"Size="50"DefaultValue="0"/>

</SelectParameters>

</asp:SqlDataSource>

Advance thanks

Anvar Sadath

[15715 byte] By [Anvar] at [2008-1-10]