Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql2005 EncryptByPassPhrase binary problem
Message
From
02/01/2011 21:01:38
 
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01494217
Message ID:
01494363
Views:
63
Thank you for your help first , you don't say, i also understand in this time...
the SQL result is in hexadecimal notation, the VB.NET in decimal.

sql and vb.net result different....

But the two method result is display :
010000007AE387A2F926CBFC67790A3BA715C148B9A3B8A057564008076C0865716527B1


So if i want to use DECRYPTBYPASSPHRASE function....
I need store the result and add the 0x....
After the result is
0x010000007AE387A2F926CBFC67790A3BA715C148B9A3B8A057564008076C0865716527B1......

that is OK la, i can use the DECRYPTBYPASSPHRASE function
Previous
Reply
Map
View

Click here to load this message in the networking platform