Digital Signature Infopath 2003 with Form Data SQL Server

Jordi Mateo — Wed, 12 Jun 2013 07:36:57 GMT

Hi All, I am new to this forum (& using InfoPath with Sharepoint!) so please bear with me! :)

Actually I'm working with Infopath 2003 with several data forms that can save data into SQL Server 2000 or 2005.

The main connection of the form (read-write data) is based in SQL server.

I would like to add a Digital Signature to some data in order to protect them.

I read the article Lab 10: Enabling Digital Signatures in InfoPath 2003 (http://msdn.microsoft.com/en-us/library/office/bb735649%28v=office.11%29.aspx) I made all the steeps:

Made the sertificate, enabled the form to digital signature, etc. etc.

- The problem is when I try to fill out the form as a final user adding the defined digital signature Infopath shows an error:

Infopath cannot to add the digital signature

Showing details:

The Id '6' is duplicated

The Id is the key field of the database table.

It seems that Infopath try to write a new register with the same Id (that the register that is editing). Is like infopath try to submit tha data to SQL server (new register) before signing.

Does anyone know if this is possible? If so, could you please explain how?! Please let me know if you need any more information to be able to help me!

Thanks in advance !! :)

General

Digital Signature Infopath 2003 with Form Data SQL Server