Form

[Simon]

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

 

[JNariss]

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

 

[Simon]

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

 

[JNariss]

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?

 

[Simon]

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