Using VB6 with MS SQL database, how can I store TIFF image (Fax) to SQL
rec., using stored proc?
Which datatype I have to use?
How can I transfer the TIFF image from Vb to the stored proc?
Thx.

Hi,

You can put it in the image field type. You don't need to use stored
procedure and you can just read/write it directly as demonstrated in the
following article:

HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q258038

HOWTO: Read and Write BLOBs Using GetChunk and AppendChunk
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q194975

Regards,
Elan Zhou
This posting is provided "AS IS" with no warranties, and confers no rights.
Got .Net?  http://www.gotdotnet.com