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