I've upgraded my tables by storing passwords generated by the pwdencrypt function in stead of encrypt. If anyone's intrested i'd be happy to sent the SQL-script for it.

The script decodes...

Perhaps giving the transaction server's user right's on the package will help.

By the way the odbc encryption method works similar:

select {encrypt N'hallo'}

compare the result to :

select {encrypt N'<abcd...z>'

and there is your list for decoding

enough on this i'll bet everyone knew it...