Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003

    Unanswered: Encryption in SQL Server2000/VB


    I have an application in SQL Server 2000 and VB as the front end. We want to encrypt the password for connecting to the database so that even the programmers will not be able to see it. Only administrator should know the password. A common db account will be used for connecting to the database. This password needs to be encrypted.
    Encryption either in VB or SQL server 2000 is fine.

    Is there a way? Thanks in advance.


  2. #2
    Join Date
    Jul 2003
    Penang, Malaysia
    I'm asuming u meant the password written in your codes.

    err I'm guessing...compile your connection parameter coding into a object file and call it in your vb?

    I know a way to encrypt ASP,vbscript thought, using Windows Script Encoder. You can find it in unser MSDN search.

    It not fool proof, but then again, I think it only encrypts script files.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  3. #3
    Join Date
    Sep 2003
    United States
    Provided Answers: 1

    Encrypt in VB.

    use VB to encypt...and have a dll to do this encryption and decryption...and embed this logic of encryption and put the password as well into this dll. Actually what i have done is, i have a file name config.txt which this dll accesses and retrives the password..and this config.txt is encrypted. And when user/developer put his password in the login dialog or any connection will be first sent to that dll and it encrypts that password and compares against the encrypted password in the file.
    >> Learn PHP/MySQL for free
    >> Free Web Hosting with PHP, MySQL, Website Builder :

  4. #4
    Join Date
    Aug 2003
    Delft, The Netherlands (EU)

    Re: Encrypt in VB.

    I have an easier solution. I developed an encryption function, and put them into an DLL. There is an "admin" executable, which shows the result of encryption, and I used the result as the real DB password.

    This DLL isn't availabe to the developer directly, but is used in the middle tier, which receives the original password from the developer, and connects to the DB with the encrypted one.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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