param.type issue with Store procedure

[Christian Perthen]

Hi,

I am getting following error

Microsoft OLE DB Provider for SQL Server error '80040e07'
Operand type clash: nchar is incompatible with image

When using
....
Set ThumbParam = Server.CreateObject("adodb.parameter")
ThumbParam.Name = "image_thumb"
ThumbParam.Type = 128 ' adBinary
ThumbParam.Value = ThumbFile.Binary
ThumbParam.Size = ThumbFile.Size
Command.Parameters.Append ThumbParam
....

The datatype for @image_thumb is image in the SPROC.

I assume the type parameter is wrong. Where can I find a list of the types.


Thanks in advance
Christian

[oj]

This might help:
[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q258038[/url]

--
-oj
RAC v2.2 & QALite!
[url]http://www.rac4sql.net[/url]



"Christian Perthen" <cperthen@dreamactive.com> wrote in message
news:ebKoZTkgDHA.2748@TK2MSFTNGP11.phx.gbl...

> Hi,
>
> I am getting following error
>
> Microsoft OLE DB Provider for SQL Server error '80040e07'
> Operand type clash: nchar is incompatible with image
>
> When using
> ...
> Set ThumbParam = Server.CreateObject("adodb.parameter")
> ThumbParam.Name = "image_thumb"
> ThumbParam.Type = 128 ' adBinary
> ThumbParam.Value = ThumbFile.Binary
> ThumbParam.Size = ThumbFile.Size
> Command.Parameters.Append ThumbParam
> ...
>
> The datatype for @image_thumb is image in the SPROC.
>
> I assume the type parameter is wrong. Where can I find a list of the

types.

>
>
> Thanks in advance
> Christian
>
>

[Bob Barrows]

Christian Perthen wrote:

> Hi,
>
> I am getting following error
>
> Microsoft OLE DB Provider for SQL Server error '80040e07'
> Operand type clash: nchar is incompatible with image
>
> When using
> ...
> Set ThumbParam = Server.CreateObject("adodb.parameter")
> ThumbParam.Name = "image_thumb"
> ThumbParam.Type = 128 ' adBinary
> ThumbParam.Value = ThumbFile.Binary
> ThumbParam.Size = ThumbFile.Size
> Command.Parameters.Append ThumbParam
> ...
>
> The datatype for @image_thumb is image in the SPROC.
>
> I assume the type parameter is wrong. Where can I find a list of the
> types.
>

[url]http://www.able-consulting.com/ADODataTypeEnum.htm[/url]

You may also benefit from my stored procedure code generator available at:
[url]http://www.thrasherwebdesign.com/index.asp?pi=links&hp=links.asp&c=&a=clear[/url]

I'm not sure, but you might have to use AppendChunk to set the parameter's
value.

Bob Barrows