Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 17 Jan 2006 10:28 GMT

Hi,

I want to create a form in InfoPath with an attachment control, that can be
sent to a form library in SHarepoint and a SQL database.
Can anyone tell me if this is possible and what's the easiest way to do this?
Do I use a web service?

thanks,
Simon

Reply to this Message

JNariss@gmail.com - 18 Jan 2006 06:27 GMT

Simon,

This link may help you submit to multiple data sources - I know it
helped me:

http://office.microsoft.com/en-us/assistance/HA012073751033.aspx

-Justine

Reply to this Message

Simon - 18 Jan 2006 09:01 GMT

Justine,

thanks, but I had problems when I tried this. As there's an attachment in
the form, it didn't want to send it to the database. Do you know if it would
be possible to send the attachment file to the form library only?

Simon

> Simon,
>
[quoted text clipped - 4 lines]
>
> -Justine

Reply to this Message

JNariss@gmail.com - 18 Jan 2006 16:05 GMT

I must have read your first question incorrectly when you implied you
wanted to send it to a library and SQL database. Couldn't you just take
off the submit option to the database and have it submitted only to the
form library?

Reply to this Message

Simon - 18 Jan 2006 16:33 GMT

Hi,
sorry, what I meant was, I do want to submit to both the library and
database, it's just that when I tried this, I got an error saying the
database couldn't accept the file from the attachment control, that it was
the wrong type, too large to fit in the database. Therefore it is only the
file that I don't want to go in the database but I can't work out how I can
submit everything BUT the file to both places.
Hope this makes more sense. Either stop the file from being stored in the
database, or forcing the database somehow to store it.
Simon

> I must have read your first question incorrectly when you implied you
> wanted to send it to a library and SQL database. Couldn't you just take
> off the submit option to the database and have it submitted only to the
> form library?

Reply to this Message