"Marc" <M***@discussions.microsoft.com> schreef in bericht
news:3E6CAD38-1D69-4675-AE4B-C41AA9034AF3@microsoft.com...
>I need to send a small amount of encrypted data using ADO from a VB 2005
>app
> to SQL Server 2005 and when the server receives the data, I need it to
> decrypt the data and then possibly change and encrypt the data and send it
> back to the VB app where I may need to decrypt it.  I have read about
> encryption in SQL Server and VB but I do not know how to get them to use
> each
> others encrypted data.  For example, can SQL Server use a symmetric key
> that
> was created in VB?
> Any help or pointing in the right direction would be greatly appreciated.
> Thanks, Marc

"Michel Posseth  [MCP]" wrote:

> The answer is yes
>
> You can just create a database project in visual studio and use managed code
> to do this
>
>  for example  :
> Create a managed code stored procedure that behaves how you want , you can
> use all the normall .Net classes
>
>
> "Marc" <M***@discussions.microsoft.com> schreef in bericht
> news:3E6CAD38-1D69-4675-AE4B-C41AA9034AF3@microsoft.com...
> >I need to send a small amount of encrypted data using ADO from a VB 2005
> >app
> > to SQL Server 2005 and when the server receives the data, I need it to
> > decrypt the data and then possibly change and encrypt the data and send it
> > back to the VB app where I may need to decrypt it.  I have read about
> > encryption in SQL Server and VB but I do not know how to get them to use
> > each
> > others encrypted data.  For example, can SQL Server use a symmetric key
> > that
> > was created in VB?
> > Any help or pointing in the right direction would be greatly appreciated.
> > Thanks, Marc
>
>
>