Encripted psw check

Thread Solved

Join Date: Apr 2008
Posts: 490
Reputation: veledrom is an unknown quantity at this point 
Solved Threads: 0
veledrom veledrom is offline Offline
Posting Pro in Training

Encripted psw check

 
0
  #1
Jul 14th, 2008
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

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. .......WHERE psw=' " & text1.text & " '
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 3,736
Reputation: nav33n is a jewel in the rough nav33n is a jewel in the rough nav33n is a jewel in the rough 
Solved Threads: 328
Moderator
Featured Poster
nav33n's Avatar
nav33n nav33n is offline Offline
Senior Poster

Re: Encripted psw check

 
0
  #2
Jul 14th, 2008
Umm.. Is it related to php ?
Ignorance is definitely not bliss!

*PM asking for help will be ignored*
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 490
Reputation: veledrom is an unknown quantity at this point 
Solved Threads: 0
veledrom veledrom is offline Offline
Posting Pro in Training

Re: Encripted psw check

 
0
  #3
Jul 14th, 2008
Sorry, this is wrong place for this post.
I do apologise
Last edited by veledrom; Jul 14th, 2008 at 3:14 pm. Reason: wrong place
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 4,171
Reputation: peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of peter_budo has much to be proud of 
Solved Threads: 479
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: Encripted psw check

 
0
  #4
Jul 15th, 2008
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
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 2,640
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Solved Threads: 245
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Posting Maven

Re: Encripted psw check

 
1
  #5
Jul 15th, 2008
Call Decript function 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 *
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 490
Reputation: veledrom is an unknown quantity at this point 
Solved Threads: 0
veledrom veledrom is offline Offline
Posting Pro in Training

Re: Encripted psw check

 
0
  #6
Jul 15th, 2008
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.

Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text)
  1. ....WHERE AES_DECRYPT(psw, 'text_key') = '" & Text1.Text & "';
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 2,640
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Solved Threads: 245
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Posting Maven

Re: Encripted psw check

 
1
  #7
Jul 15th, 2008
You're Welcome...
Happy coding
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:



Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC