Thanks everyone who answerd my questian. Since I was changing some 
old app I still used the appendchunk, evnthough Itried stream object and 
it worked fine. I passed this RS to amiddle tier RDS component and updated 
from there. Cool

Thanks again
Vinod

> Look at Chris Tacke's post... DO NOT USE GetChunk or AppendChunk these 
are
> old and slow legacy methods.
> 
> Thank You
> Donald Burr
> C.I.O.
> Nationwide Auction Systems
> City of Industry, California
> Voice:  (xxx) xxx-xxxx  Ext. 248
> Fax:  (xxx) xxx-xxxx
> Cel:  (xxx) xxx-xxxx
> E-Mail: dburr@n... <mailto:dburr@n...>
> 
> 
> 
> -----Original Message-----
> From: Vinod Thomas [mailto:vthomas@a...]
> Sent: Tuesday, August 14, 2001 1:43 PM
> To: professional vb
> Subject: [pro_vb] saving Image to SQL Server
> 
> 
> Hi,
> How can I save an image file to the SQL Server database. I cannot
> use recordset( May be I am wrong) update since I am suing RDS componets 
in
> my apps.
> I am trying to execute an Insert, update from the client, but if I use
> the byte varaible along woth the SQL statement it gives me a type 
mismatch
> This seems to be very common, sorry I couldn't find any answers
> Thanks for your help
> Vinod
> 
>