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
Alwyn,
Take a look at this site: http://www.activecrypt.com/index.htm. You might
want to test the xp_crypt procedures.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Alwyn Pereira" <alwynpereira@.hotmail.com> wrote in message
news:ucXSc9sqEHA.3748@.TK2MSFTNGP09.phx.gbl...
> 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
>