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
>

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