Encryption for sql server

hey ppl..
i am creating a client that can access straight into the sql db using vb.net.
is there a way encrypt the data from the client and the sql server will decrypt the data and visa versa?Your best choice is to use some flavor of VPN to get your data to the server safely. A poor alternative (although pure MS-SQL) is to use Named Pipes, which can do feeble encryption at relatively low performance.

-PatP|||is there anyway to make a simple encryption? small enough so that it encrypts the data and it does not effect performance?|||See if this helps you:

http://www.developerfusion.com/show/4647/

You would basically be storing the data encrypted. The problem is when you go to search the data of course. If you need to encrypt all traffic, you can look at what Pat said. I would recommend against it. There are also several hardward level tools for this, but they are expensive.