I just started to get the above error all of a sudden during the bulk import. 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. My web application timeout is set to 3000, but it times in less than a minute. The culprit seems to be the AddPhoto function. I restarted SQL Server 2000, IIS, and the whole machine, but to no avail. There's no code change since it was working earlier in the day. Any ideas?
Description: 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.
Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
Source Error:
Line 125: command.Parameters.Add(New SqlParameter("@BytesPoster", ResizeImageFile(BytesOriginal, 198)))
Line 126: command.Parameters.Add(New SqlParameter("@BytesThumb", ResizeImageFile(BytesOriginal, 100)))
Line 127: command.ExecuteNonQuery()
Line 128: End Sub
|