encrypt data on SQL Server

al4629740
al4629740 used Ask the Experts™
on
When I am opening a recordset over the internet on SQL server 2008, I am wondering if my data is secure.  Do I need to encrypt my data or can I somehow.

We have several users that are using a VB6 application over the internet to access a server that is behind a firewall.  What issues do I need to think about in order to protect the sensitive data that is going through the internet?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Glanced up at my screen and thought I had coded the Matrix...  Turns out, I just fell asleep on the keyboard.
Most Valuable Expert 2011
Top Expert 2015
Commented:
How is your VB6 application connecting to the database? Unless you are using HTTPS (or perhaps via a VPN), your data is going out over the wire unencrypted. You might use public key encryption to ensure your data is safe.

Author

Commented:
Can I do that in vb6?
kaufmedGlanced up at my screen and thought I had coded the Matrix...  Turns out, I just fell asleep on the keyboard.
Most Valuable Expert 2011
Top Expert 2015

Commented:
I don't immediately see why you wouldn't be able to, but I'll have to defer. It's been too long since I've done VB6, and at that time in my career I wouldn't have been able to tell you how to do it anyway  : \

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial