0

Hi,

I have encripted password column in my table. I use VB6 code below to check password but it doesn't work. I think i have to call a function to decrypt it. Where and which function do i use in my sql code below with text1.text.

Thanks

.......WHERE psw=' " & text1.text & " '
4
Contributors
6
Replies
7
Views
9 Years
Discussion Span
Last Post by Jx_Man
1

Call Decript function before check. ......WHERE Decript(psw)=' " & text1.text & " ' Or
You can encript inputed pasw before check ......WHERE psw=' " & Encript(text1.text) & " '

0

Thank you Jx,

I have done it with your solution and solved. In Insert clause encrypt text1 with "AES_ENCRYPT". After i used code below to check text1.

....WHERE AES_DECRYPT(psw, 'text_key') = '" & Text1.Text & "';
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.