Although it is possible to store images in sQL Server, you'll have better performance if you continue to store the images on the server (file or web) and store the filename within the table.
OTOH, if you must store the image within the table, I've had the best luck using ADO's GetChunk and AppendChunk methods.
-Mike