Encryption: VB 2005 And SQL Server 2005

[Marc]

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
"Marc" <Ma**@discussions.microsoft.comschreef in bericht
news:3E**********************************@microsof t.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

[Marc]

Great idea. Thanks for your help.
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" <Ma**@discussions.microsoft.comschreef in bericht
news:3E**********************************@microsof t.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