Inserting File Attachments into SQL 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carolus.holman - 05 Oct 2004 17:43 GMT

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

Reply to this Message

Scott Roberts [MSFT] - 05 Oct 2004 21:55 GMT

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

>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
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message