[RESOLVED] Storing a picture in SQL 2000

[1druid1]

Hi All

I have the following code that I use to convert a picture into bytes.

 Dim strImageFilePath As String = _ 
LblPicture.Text 
Dim fsImageFile As New FileStream(strImageFilePath, _ 
FileMode.Open, FileAccess.Read) 
Dim bytImageData(fsImageFile.Length() - 1) As Byte 
fsImageFile.Read(bytImageData, 0, bytImageData.Length) 
fsImageFile.Close()

This then gets used to store into an SLQL 2000 VarBinary field.

I thought the above would work but its only letting me save pictures that are under 8k in size, but I need to be able to save much bigger files than that.

Any help is appreciated.

Cheers

Dougie