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

If you do not hold both pieces of the key, then whether you are using the 3DESWrapper or something else, you will not be able to decrypt this.  I recommend the approach I mentioned using the BO to do this.  This way it is totally encrypted while stored in SQL Server, yet you are in control.