SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Encrypting fields in sql server

    i need to store a set of passwords using encryption in sql server; however, in using ENCRYPT('pswd') I don't get the results that I'm looking for.

    can anyone help?

    i'm using asp as the s-s code.

    thanks!

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,268
    Mentioned
    116 Post(s)
    Tagged
    1 Thread(s)
    You could use SHA-256 encryption and encrypt it before you insert it into the database.

    You can do a search on SHA-256, or you can go to Snitz Forums and get the encryption code from there. That is the encryption they use.

    Look in inc_header.asp and one of the inc_functions pages for an example of how they handle it. Sorry, I don't remember which one and I don't have a version of the source code in front of me....
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  3. #3
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy

    i've found the rc4 code as well. however, i shouldn't have to handle this in asp but rather sql server 2000!!! for crying out loud microsoft SUCKS!

    anyhow, the reason this is, is due to the fact that asp entry/retrieval of information is only one front to the app others could be vb, jsp, java, etc.

    thanks anyway.

  4. #4
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is this encryption method just a fantasy in my mind? sql server 2000 doesn't have this? can someone please help?!






    dlg

  5. #5
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Thumbs down

    "he holds the baseball tightly while he approaches his server."

    he quietly steps closer and closer to the ole Seequel and whispers, "hold on little guy, you wanna play baseball?".

    as innocently as an Enron exec. ole Seequel replies in a very excited tone, "YES!".

    Seequel barely finishes his reply when out of nowhere a loud bang fills the room. the bat now lays on the floor next to the blades from seequel's insides.

    the only solution for ms solutions.


    --- sorry, just playing around.

    still no success! i give up!

    dlg

  6. #6
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sql server 2000 still sucks, I haven't been able to find a solution..


    CAN ANYONE HELP?!?!?!?!?!?!?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •