| | |
Encripted psw check
Thread Solved |
•
•
Join Date: Apr 2008
Posts: 566
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: 566
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
Views: 812 | Replies: 6
| Thread Tools | Search this Thread |
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add append application basic beginner bmp calculator cd cells.find code college column component connection connectionproblemusingvb6usingoledb copy creat data database datareport date delete desktop dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename filter form group hardware header iamthwee ide image internetfiledownload label list listbox listview liveperson looping machine mail match metadata microsoft movingranges open oracle pos prime print printer program prompt random range range-objects readfile reading record remotesqlserverdatabase report save search sendbyte sites sort spectateswamp sql sql2008 sqlserver struct table tags textbox time timer urldownloadtofile variable vb vb6 vb6.0 vba visual visualbasic visualbasic6 web






