Data encryption for results of query using ADO

Hi,
I'm using ADO to connect to a SQL Server.
I want to execute a query which reads sensistive information and ensure that
the results of the query cannot be sniffed on the network
Can I enable encryption for a specific connection to the SQL Server without
forcing either the client machine or sql server to enable
full fledged encryption. I have only one query which returns sensitive
information, hence I do not wish to enable encryption for the all sql server
connections/
using certificates via 'Force Protocol Encryption'
Thanks,
Alwyn
There isn't anything built-in to support this. I'm afraid you're going
to have to roll your own.
--Mary
On Mon, 4 Oct 2004 19:11:49 +0530, "Alwyn Pereira"
<alwynpereira@.hotmail.com> wrote:

>Hi,
>I'm using ADO to connect to a SQL Server.
>I want to execute a query which reads sensistive information and ensure that
>the results of the query cannot be sniffed on the network
>Can I enable encryption for a specific connection to the SQL Server without
>forcing either the client machine or sql server to enable
>full fledged encryption. I have only one query which returns sensitive
>information, hence I do not wish to enable encryption for the all sql server
>connections/
>using certificates via 'Force Protocol Encryption'
>Thanks,
>Alwyn
>
sql