Storing Large Files In The SQL Server 2005

I have a table that I'm inserting a file into and using the Image data type to store the binary object.  Now the code below works fine for files around 1.5 MB, but anything larger and it's like the code won't even execute and I get a Page Not found error.

I'm in the process of running some traces to find out what's going on in the backend, but I'm assuming there's something amiss with my code.  The Image data type should handle files that size with no problem but for some reason it isn't.

Does anyone see anything wrong?

Thanks

Dim iLength As Integer = CType(File1.PostedFile.InputStream.Length, Integer)

If iLength = 0 Then Exit Sub 'not a valid file

Dim sContentType As String = File1.PostedFile.ContentType

Dim sFileName As String, i As Integer

Dim bytContent As Byte()

ReDim bytContent(iLength) 'byte array, set to file size



'strip the path off the filename

i = InStrRev(File1.PostedFile.FileName.Trim, "")

If i = 0 Then

sFileName = File1.PostedFile.FileName.Trim

Else

sFileName = Right(File1.PostedFile.FileName.Trim, Len(File1.PostedFile.FileName.Trim) - i)

End If

conn = New SqlConnection(eco)

conn.Open()

cmd = New SqlCommand("INSERT INTO ECO_Attachments (ECOID, FromType, DocName,OldRev,NewRev,NtLogin,DisplayName, FileName, FileSize, FileData, ContentType) VALUES (@ECOID, @FromType,@DocName,@OldRev,@NewRev,@NtLogin,@DisplayName, @FileName, @FileSize, @FileData, @ContentType) ")

cmd.Connection = conn

Try

File1.PostedFile.InputStream.Read(bytContent, 0, iLength)

With cmd

.Parameters.Add("@ECOID", SqlDbType.Int)

.Parameters.Add("@FromType", SqlDbType.NVarChar, 50)

.Parameters.Add("@DocName", SqlDbType.NVarChar, 250)

.Parameters.Add("@OldRev", SqlDbType.NVarChar, 50)

.Parameters.Add("@NewRev", SqlDbType.NVarChar, 50)

.Parameters.Add("@NTLogin", SqlDbType.NVarChar, 100)

.Parameters.Add("@DisplayName", SqlDbType.NVarChar, 200)

.Parameters.Add("@FileName", SqlDbType.NVarChar, 255)

.Parameters.Add("@FileSize", SqlDbType.Real)

.Parameters.Add("@FileData", SqlDbType.Image)

.Parameters.Add("@ContentType", SqlDbType.NVarChar, 50)

.Parameters("@ECOID").Value = ECOID

.Parameters("@FromType").Value = From

.Parameters("@DocName").Value = DocName

.Parameters("@OldRev").Value = OldRev

.Parameters("@NewRev").Value = NewRev

.Parameters("@NTLogin").Value = NTLogon

.Parameters("@DisplayName").Value = DisplayName

.Parameters("@FileName").Value = sFileName

.Parameters("@FileSize").Value = iLength

.Parameters("@FileData").Value = bytContent

.Parameters("@ContentType").Value = sContentType

.ExecuteNonQuery()

'.ExecuteScalar()

End With

Catch ex As Exception

Response.Write(ex)

'Handle your database error here

conn.Close()

End Try