I am using SQL 2005 to encrypt data using the Tripe_Des protocol.  I'd like to use the TripleDesWrapper from strataframe within my app. to decrypt.  Is this possible?

Sql 2005 uses a password for encryption.  Mine is 24 characters long.

In my strataframe app. I use the same password for the encryption key and use just the first 8 characters for the vector.

Any help would be appreciated as Sql 2005 can decrypt the data but my app replies that it is bad data within the business object when attampting to decrypt.

Thank You,

Cory

Cory Cookson

Software Developer

Occupational Health Research

I don't totally understand your post in regards to where you are encrypting your data.  If you are allowing SQL Server to encrypt the data versus the 3DESWrapper, then you MUST make sure that your key and ventors are identical.  But generally, I never do it that way.  I will create a custom property that exposes the field that I want to encrypt/decrypt.  There is a sample of this in the CustomerCreditCardsBO in StrataFlix.  It isn't plumbed into a dialog at the moment, but you can see the logic within the BO showing how to encrypt/decrypt a property to and from a database using the 3DESWrapper.