SQL Database Integration

Re: Submit to "SQL Server" a digitally signed form

josera — Wed, 12 Jan 2011 04:00:18 GMT

I think I found the reason why signed forms cannot be submitted to a database. If you use Web services, in one of the Data connection wizard windows, there is a check box that reads:

Submit data as string. Note: Digitally signed data must be submitted as a string to preserve white spaces.

This means that during the submit process white spaces are removed and then the digital signature hash of the file will not match. Probably, this is what happens during the DB submit too.

Even though there is a solution from Infopath for Web services submit, I could not find any solution for DB submit.

Has anyone found how to submit a signed form to a DB with a direct Infopath solution or with any workaround?

Any help will be much appreciated.

Josera

Re: Submit to "SQL Server" a digitally signed form

Patrick Halstead — Fri, 07 Jan 2011 12:35:51 GMT

Hi Josera,

Not sure. We built a Web Service to submit to databases and our Web Service (DBXL) supports signed forms just fine. My guess is that you are using a direct DB connection and that somehow changes during the submit process as a result of where your digisigs are located in the form. Random guess though ...

Best of luck!

Submit to "SQL Server" a digitally signed form

josera — Fri, 07 Jan 2011 10:16:39 GMT

Hi,

I use Infopath 2007, VBScript and "SQL Server 2008". My forms are digitally signed and at the end of the process they are saved and I also need its data to be stored in the database. The form contains the signature of three different people and when the third signature is done, the form is saved and then the data should be stored in the DB.

The problem is that when I submit it, I get the error:
"This value has been digitally signed and cannot be changed"

Of course I do not try to change anything, I just submit. I have been trying with different databases, different forms, different trust settings and basically everything that I could think of but If it signed I always get the same error. When there are no signatures, there are never problems to submit.

If I only had one signature, I could first submit and then sign it and save it. But at the end of the process I already have the two previous signatures so there is no way to submit it.

Could somebody tell me if there is a way to submit a signed form to "SQL Server"? Your help will be very much appreciated.

Josera