Encryption: VB 2005 And SQL Server 2005

[Guest]

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]]

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

 

[Guest]

Great idea. Thanks for your help.
Marc

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