SQL SP4 & image

[draganss]

VS.NET 2002
SQL 2000 with SP3 or SP4
//////////////////////////
I'm passing an image as array of bytes to the SQL Stored Procedure which inserts it to the database.

ALTER PROCEDURE sp_InsertBarCode
@ImgBarCode image=null,
AS
INSERT INTO BarCodeTable(ImgBarCode)
VALUES(@ImgBarCode)
RETURN @@ERROR

When I'm using this code with SQL database with SP2 or SP3 I can insert images up to ~30 KB large,
but with SQL database with SP4 images can be maximum 4 KB large.

Error I'm getting is:
A severe error occured on the current command. The result, if any, should be discarded.

The field in the table is defined as Data Type Image with Lenght=16.

Any suggestions?
Thank you.

Marin

 

[draganss]

Addition to the post

SQL log:

2006-11-29 12:19:52.18 spid55 Error: 17805, Severity: 20, State: 3
2006-11-29 12:19:52.18 spid55 Invalid buffer received from client..

 

[draganss]

Searching the web I found following link that solved my problem:

http://www.standardio.org/article.aspx?id=215