There is no error, there isn't enough knowledge. Well, the conditions are:

IIS v 4.0

MS-SQL Server v.6.5



We have a table that was created in this way:

******

 create table pics(

  id int,

  pic image)

******



 We want to push into this table rather small(15-20 kb) pictures and then pull them back.



This seems to be the standart task, so if there is any FAQ, that describes the solution - this would be great.

 Anyway - thanks for help or just reading.

Here's a link to the good old Microsoft Knowledge Base which deals with 

retrieving image data from SQL Server via ASP.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q173308



And another link about how to save image data using ADO stream - this one 

is VB example but I'm sure it can be easily adapted to ASP.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q258038



Also if you have SQL Server Books On Line there's stuff in there about 

image fields.



HTH

Phil

> There is no error, there isn't enough knowledge. Well, the conditions 

are:

> IIS v 4.0

> MS-SQL Server v.6.5

> 

> We have a table that was created in this way:

> ******

>  create table pics(

>   id int,

>   pic image)

> ******

> 

>  We want to push into this table rather small(15-20 kb) pictures and 

then pull them back.

> 

> This seems to be the standart task, so if there is any FAQ, that 

describes the solution - this would be great.

>  Anyway - thanks for help or just reading.