Encryption in SQL Server2000/VB

Hi,

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.

Raj

Hello
You can easily encrypt the password by capturing the actual password what the end user typed,with that add up 50 so that and find ascii key value for that character and store that combination in the database.
When the user enters the actual password u can test it in the reverse order what we are doing to store it in the database.So that no known can see the password

you could try creating a dll to give the programmers the db link... so the actual db connecting would be done in there which is hardcoded with the password.

i dont see m2hari's answer really work. not even if you use a more complex enc/dec method coz the programmer would still have to decrypt it to connect to the db. and thus get the decrypted pass too ...