• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 141
  • Last Modified:

How to produce a SHA-1 hash function in vb6 in order to save it to a table

Please help us for a code in vb6 to hash SHA-1 a string before I saving to a table.

Thank you in advance
0
rayluvs
Asked:
rayluvs
  • 5
  • 3
1 Solution
 
JesterTooCommented:
Perhaps you meant "encrypt" instead of "hash" since hashes are one-way and I'd assume you want to decrypt it sometime.  If so, then here is a link that describes hot to accomplish that.

https://support.microsoft.com/en-us/kb/821762
0
 
rayluvsAuthor Commented:
Yes, that's what we need, one-way.  We hash sha1 the result save it to table.

Can this be done in vb6?
0
 
JesterTooCommented:
Ok, take a look at this link.  It has source code that purports to do what you want.

http://vb.wikia.com/wiki/SHA-1.bas
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
JesterTooCommented:
in the event that code proves to be faulty, search the internet for this phrase...

"vb6 sha1 source code philip ciebiera"
0
 
rayluvsAuthor Commented:
Thanx!!! Found a code thet works excellent and we compared it to MS SQL HASHBYTE function is almost the exact!

We say exact because the SQL function always returns "0x" when the vb code doesn't.

For example the has for 'experts-exchange' in

vb6 code is:             9022fc0e1985bb7c0ac60792ee3fbe3029af0424

in SQL is:                 0x9022FC0E1985BB7C0AC60792EE3FBE3029AF0424

                                 notice "0x"

We extract the "0x" from SQL statement result and both SQL & VB results are the same.

Is there a reason for the "0x" and should we be concerned?
0
 
JesterTooCommented:
yes, that is not actually a part of the hash.  It is there to signify that the remaining characters are hexidecimal. It is safe to just strip it off as you did.
0
 
rayluvsAuthor Commented:
Thanx!!! You really helped us!!
0
 
JesterTooCommented:
You're welcome.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now