<div>
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 &nbsp;: \
</div>


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  : \

<div>
<div class="content wysiwyg-content">
When I am opening a recordset over the internet on SQL server 2008, I am wondering if my data is secure. &nbsp;Do I need to encrypt my data or can I somehow.<br />
<br />
We have several users that are using a VB6 application over the internet to access a server that is behind a firewall. &nbsp;What issues do I need to think about in order to protect the sensitive data that is going through the internet?
</div>
</div>


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?

encrypt data on SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.