Inserting File Attachments into SQL 2000

[carolus.holman]

I just read an article on MSDN on how to deal with file attachments. Is it
possible to use a SQL 2000 database with the image datatype to store and
retrieve file attachments and images? I have found one article which outlined
the method using a webservice, but infopath wouldn't allow me to bind to the
datatype.

Thanks

 

[Scott Roberts [MSFT]]

InfoPath file attachment controls can only bind to base64 data. Is the
image datatype in SQL 2000 base64 or some other type of format? Either way,
even if you aren't able to bind the file attachment control to this
datatype, you can write business logic to convert the data to/from base64 in
the format that the file attachment control will understand that is
described in the article you referenced.

- Scott