Unable to Import Pictures Any Morehttp://forums.asp.net/t/904569.aspx/1?Unable+to+Import+Pictures+Any+MoreThu, 28 Jul 2005 19:23:41 -0400904569996945http://forums.asp.net/p/904569/996945.aspx/1?Unable+to+Import+Pictures+Any+MoreUnable to Import Pictures Any More I just started to get the above error all of a sudden during the bulk import.&nbsp; I was importing pictures all day and all of a sudden, I started getting this error message and I cannot import a single picture any more.&nbsp; My web application timeout is set to 3000, but it times in less than a minute.&nbsp; The culprit seems to be the AddPhoto function.&nbsp; I restarted SQL Server 2000, IIS, and the whole machine, but to no avail.&nbsp; There's no code change since it was working earlier in the day.&nbsp; Any ideas?<br> <br> <strong>Description: </strong><font face="Arial">An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <br> <br> </font><b>Exception Details: </b><font face="Arial">System.Data.SqlClient.SqlException: Timeout expired. &nbsp;The timeout period elapsed prior to completion of the operation or the server is not responding.<br> The statement has been terminated.<br> <br> </font><b>Source Error:</b><font face="Arial"> <br> <br> </font> <table bgcolor="#ffffcc"> <tbody> <tr> <td><pre class="prettyprint"><pre>Line 125: command.Parameters.Add(New SqlParameter(&quot;@BytesPoster&quot;, ResizeImageFile(BytesOriginal, 198)))</pre> Line 126: command.Parameters.Add(New SqlParameter(&quot;@BytesThumb&quot;, ResizeImageFile(BytesOriginal, 100))) Line 127: command.ExecuteNonQuery() Line 128: End Sub <pre></pre></pre></td> </tr> </tbody> </table> 2005-07-23T02:58:03-04:001003148http://forums.asp.net/p/904569/1003148.aspx/1?Re+Unable+to+Import+Pictures+Any+MoreRe: Unable to Import Pictures Any More I forced a close of the connection and the problem was solved. 2005-07-28T19:23:41-04:00