Encryption: VB 2005 And SQL Server 2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Great idea. Thanks for your help.
Marc

Michel Posseth said:
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
Click to expand...
 
Back
Top