Newbie Questions

Re: Encryption

Hilary Stoupa — Fri, 14 May 2010 22:22:21 GMT

I think you may need to alter your query statement in code prior to running it. It seems to me that you are instead altering the SQL statement for the main data connection. Here's an MSDN page that may help.

Re: Encryption

KidTech — Fri, 14 May 2010 12:22:27 GMT

Its is being done with a SSL cert on the web server.

I have the code to decrypt and it works but this is the issue.

I created the InfoPath form via connection to the SQL DB on another server. Once the form was linked I have the Query and Mydata fields. I created the entire form with only one query field (Application Date). When I look at the SQL Statement it is like this (abbreviated).

select "EmpLName","EmpFName","EmpMI","AppDate"," ApplicationID","SSN_Encrypt" from "dbo"."Tablename" as "Tablename"

I tried doing this-

OPEN SYMMETRIC KEY "Keyname" (no quotes)

DECRYPTION BY CERTIFICATE "Certname"; (no quotes)

select "EmpLName","EmpFName","EmpMI","AppDate"," ApplicationID","

CONVERT(char, DecryptByKey(keyname))

AS 'SSN'

FROM dbo.Tablenamee" as "Tablename"

What this does is take away my query field. It becomes unbound and I only have MyData fields avaiable in the datasource section. The run query cmd button works and the SSN comes in correctly but It brings in all applications submitted to the DB.

I need to be able to query on the appdate.

Hope this helps

Re: Encryption

Hilary Stoupa — Thu, 13 May 2010 21:55:03 GMT

Great! How is the SSN being encrypted?

Re: Encryption

KidTech — Thu, 13 May 2010 16:29:39 GMT

Yes I have the code

Re: Encryption

Hilary Stoupa — Thu, 13 May 2010 16:22:53 GMT

Decrypting will require knowledge of how the SSN was originally encrypted. Do you have access to the code that the web application uses to encrypt the SSN? Or can the developer for that application tell you how the information is encrypted?

You will need to use code to decrypt. You can find information on this at sites like StackOverflow, which may help you get started.

Encryption

KidTech — Thu, 13 May 2010 14:07:14 GMT

I have an online web form that when submitted dumps into a SQLDB. I have created an InfoPath template that connects to that DB with all the associated fields. I have one query field (application date).

When I query the date all applications that were submittted come in correctly. This is where I am stuck-

One of the fields on the form is SSN- When the web form is submitted to the DB the SSN is encrypted. When I query the application date-all the data comes in but the SSN comes in encrypted.

How do I get the SSN converted back to what was typed in on the form. I have read to use custom code but I am new to InfoPath so where does it go or can someone point me to an article explaining how to do this?

Russ