| | |
Encripted psw check
Thread Solved |
•
•
Join Date: Apr 2008
Posts: 490
Reputation:
Solved Threads: 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
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
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
.......WHERE psw=' " & text1.text & " '
Moved to VB section
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Call Decript function before check.
Or
You can encript inputed pasw before check
......WHERE Decript(psw)=' " & text1.text & " ' Or
You can encript inputed pasw before check
......WHERE psw=' " & Encript(text1.text) & " ' Last edited by Jx_Man; Jul 15th, 2008 at 8:56 am.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Apr 2008
Posts: 490
Reputation:
Solved Threads: 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.
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.
Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
....WHERE AES_DECRYPT(psw, 'text_key') = '" & Text1.Text & "';
You're Welcome...
Happy coding
Happy coding
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
![]() |
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Help! Database system on LAN
- Next Thread: Print copies in VB6 issue
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows






