SQL Server & File Attachment

[Simone]

Hi! I'm a beginner and I have a problem. I have to develop a Infopath form
connected to a SQL Server DataBase: it is like an interface to
insert/delete/do query in my database table. The problem is that each record
must have a file attachment attribute, that is not supported by Infopath in
order to do submit connection: how could I do? I think I should save my files
in a estabilshed folder and save their name in each single record, but how
can I get file attachment's name from Infopath?
Thank you all! Sorry for my no-perfect english!
Simone

 

[Franck Dauché]

Hi Simone,

Why don't you use a file attachment control with a BLOB on the SQL Server
Side?

Regards,

Franck Dauché

 

[Simone]

I can't do it because Infopath doesn't allow me to submit that kind of data...
If I put a BLOB attribute in SQL Server, Infopath doesn't create a Database
connection...
Try to do it if you want!
Have you got any other idea??
Thank you so much!
Simone

 

[Franck Dauché]

Hi Simone,

Check:
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=1008
Next if you do a search in that forum for "BLOB attachment", you will find
references that may put you on the right track...

Regards,

Franck Dauché