If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

SQL Server image datatype and inserts

This is my first time using image datatypes. I am trying to send from VB a
byte array and insert it into a image column using ADO and a sp. I am
getting an error saying that the datatype is incorrect. Here is my sp:

Re: SQL Server image datatype and inserts

"Daniel Reber" <dreber@dminconline.com> wrote in message
news:3c42eeca@147.208.176.211...
> This is my first time using image datatypes. I am trying to send from VB
a
> byte array and insert it into a image column using ADO and a sp. I am
> getting an error saying that the datatype is incorrect. Here is my sp:
>
> create procedure dp_pt_report_definition
>
>
> @report_definition varbinary(128),
> @report_id int output
>
>
>
> as
>
> insert into dbo.pt_report_definition (report_definition)
> values (@report_definition)
>
> set @report_id = scope_identity()
>
> return 0
>
> Is there anything wrong with the sp? I already tried changing
> @report_definition to image and I still get the same error.
>
> I just want to rule out if it is the sp or not.
>
> TIA
> Daniel Reber
> Datamasters, Inc
>
>