December 20, 2011 at 5:02 pm
Hello, converting from Informix to SQL Server Database. The encryption output for the TDES Algorithm between Informix and SQL SERVER differs in length as well as the value (i.e. the SQL SERVER always starts with 0x00 with length of 52; informix always starts with 1 and position 6 thru 10 is AAAA with length of 43).
For example, for a string value of 00015136TRCA
INFORMIX shows: 1R7j/AAAAEASO2vk2MkmZPNTfAThYuOWhp1rz+frpam
SQL SERVER shows: 0x00F23C68339B4643AA9923E4E78B8A8101000000A0C9530B3ADA3188D1A6B76CFA8B6E4D604E80CF835D616E56B19E2F0E34491D
If the encryption methodology is not standard and software dependent, then I guess there's nothing I can do; else I'd appreciate if someone explain or point me to the right direction.
Thank you.
December 20, 2011 at 5:10 pm
It's not clear what you're asking.
Also, is this the TDS data stream or something else?
December 21, 2011 at 9:50 am
I think the OP may mean Triple DES which is typically abbreviated TDEA, not TDES.
You may be comparing apples to oranges but I cannot say for sure because I do not have experience working with Informix but the Informix string looks like an ANSI representation of the encrypted string whereas the SQL Server string looks like a standard ANSI representation of a Binary value (noted by the leading 0x). Can you show how you are doing the encryption in SQL Server? have you tried reversing the encryption on both systems to see if you can validate you did not lose data?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply