Very Computer

Hello,

I have an application that stores images in the database. I use SQL Server
2000 and VB.NET.  I have a table with a column of type image.  I also have a
stored procedure that does the insert with a parameter of type image.  The
local data type being passed to the stored procedure is a byte array
(byte()).

A 6k image stores just fine. At 32k, I get the following error:

---------------------------------------------------
A severe error occurred on the current command. The results, if any, should
be discarded. at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior,
RunBehavior runBehavior, Boolean returnStream) at
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
---------------------------------------------------

And, if I look in the event viewer, I see that MSSQLSVR reports the
following error:

---------------------------------------------------
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
---------------------------------------------------

Has anyone seen this? I found some old support documents talking about
problems with SQL Server 6.5, but nothing on SQL Server 2000 (which is what
I use).

Thanks!

Brian

I want to add.... that everything works fine without a stored procedure.....

Quote:> Hello,

> I have an application that stores images in the database. I use SQL Server
> 2000 and VB.NET.  I have a table with a column of type image.  I also have
a
> stored procedure that does the insert with a parameter of type image.  The
> local data type being passed to the stored procedure is a byte array
> (byte()).

> A 6k image stores just fine. At 32k, I get the following error:

> ---------------------------------------------------
> A severe error occurred on the current command. The results, if any,
should
> be discarded. at
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior,
> RunBehavior runBehavior, Boolean returnStream) at
> System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> ---------------------------------------------------

> And, if I look in the event viewer, I see that MSSQLSVR reports the
> following error:

> ---------------------------------------------------
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> ---------------------------------------------------

> Has anyone seen this? I found some old support documents talking about
> problems with SQL Server 6.5, but nothing on SQL Server 2000 (which is
what
> I use).

> Thanks!

> Brian

I had a similar problem with text and ntext.

When adding the parameter to the Stored Procedure you have
to make sure that you set the type to SqlDbType.image AND
you have to set the size to the actual size of your image.
If your image is 33000 bytes, set the size to 33000.

Works for me, but I dont understand why I have to set the
size.

Regards,
Mikael

Quote:>-----Original Message-----
>Hello,

>I have an application that stores images in the database.
I use SQL Server
>2000 and VB.NET.  I have a table with a column of type

image.  I also have a

Quote:>stored procedure that does the insert with a parameter of
type image.  The
>local data type being passed to the stored procedure is a
byte array
>(byte()).

>A 6k image stores just fine. At 32k, I get the following
error:

>---------------------------------------------------
>A severe error occurred on the current command. The

results, if any, should

Quote:>be discarded. at
>System.Data.SqlClient.SqlCommand.ExecuteReader

(CommandBehavior cmdBehavior,

Quote:>RunBehavior runBehavior, Boolean returnStream) at
>System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
>---------------------------------------------------

>And, if I look in the event viewer, I see that MSSQLSVR
reports the
>following error:

>---------------------------------------------------
>Error: 17805, Severity: 20, State: 3
>Invalid buffer received from client.
>---------------------------------------------------

>Has anyone seen this? I found some old support documents
talking about
>problems with SQL Server 6.5, but nothing on SQL Server
2000 (which is what
>I use).

>Thanks!

>Brian

>.

Thanks Mikael -- by setting the size, do you mean the parameter definition?
I can't check right now, but I don't think data type image has a size
parameter.

B

Quote:> I had a similar problem with text and ntext.

> When adding the parameter to the Stored Procedure you have
> to make sure that you set the type to SqlDbType.image AND
> you have to set the size to the actual size of your image.
> If your image is 33000 bytes, set the size to 33000.

> Works for me, but I dont understand why I have to set the
> size.

> Regards,
> Mikael

> >-----Original Message-----
> >Hello,

> >I have an application that stores images in the database.
> I use SQL Server
> >2000 and VB.NET.  I have a table with a column of type
> image.  I also have a
> >stored procedure that does the insert with a parameter of
> type image.  The
> >local data type being passed to the stored procedure is a
> byte array
> >(byte()).

> >A 6k image stores just fine. At 32k, I get the following
> error:

> >---------------------------------------------------
> >A severe error occurred on the current command. The
> results, if any, should
> >be discarded. at
> >System.Data.SqlClient.SqlCommand.ExecuteReader
> (CommandBehavior cmdBehavior,
> >RunBehavior runBehavior, Boolean returnStream) at
> >System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> >---------------------------------------------------

> >And, if I look in the event viewer, I see that MSSQLSVR
> reports the
> >following error:

> >---------------------------------------------------
> >Error: 17805, Severity: 20, State: 3
> >Invalid buffer received from client.
> >---------------------------------------------------

> >Has anyone seen this? I found some old support documents
> talking about
> >problems with SQL Server 6.5, but nothing on SQL Server
> 2000 (which is what
> >I use).

> >Thanks!

> >Brian

> >.

    Do you specify a length for the buffer you send (in the parameter declaration)?

        FB

Quote:> Hello,

> I have an application that stores images in the database. I use SQL
> Server 2000 and VB.NET.  I have a table with a column of type image.  I
> also have a stored procedure that does the insert with a parameter of
> type image.  The local data type being passed to the stored procedure is
> a byte array (byte()).

> A 6k image stores just fine. At 32k, I get the following error:

> ---------------------------------------------------
> A severe error occurred on the current command. The results, if any,
> should be discarded. at
> System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at
> System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> ---------------------------------------------------

> And, if I look in the event viewer, I see that MSSQLSVR reports the
> following error:

> ---------------------------------------------------
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> ---------------------------------------------------

> Has anyone seen this? I found some old support documents talking about
> problems with SQL Server 6.5, but nothing on SQL Server 2000 (which is
> what I use).

        Do you supply the right size of the imagedata (in bytes) to the
        stored procedure's image parameter? If you don't, the image gets
        chopped of and/or will cause other errors.

--
        FB

        Get my free, open source .NET software at:      
        http://www.sd.nl/software