[RESOLVED] Encryption

[hellilyntax]

Hi guys...

i really need some advice on this one...

i create a vb program to update my SQL Server on my hosting company
which will update directly from data on my local pc to the server.
my worry is, the data isnt encrypted. i really dont know what format does it send...is tha plain text? if its a plain text, somebody may be able to read it right?

i guess maybe i have to encrypt the data before submit through the net and decrypt it before store it in SQL Server.

my question is, on local side, i can trigger all the data to be encrypted before submission but how to decrypt it when it reach SQL Server?
do i have to create a decrypt program at server side?

can anyone suggest me anywhere to find resource or components for encryption. i never done this before and dunno how things work....

[Hack]

can anyone suggest me anywhere to find resource or components for encryption. i never done this before and dunno how things work....

Look in our VB6 codebank. There are examples of encryption and decryption there.

[westconn1]

probably you could leave it encrypted on the server an decode it on any client machines as they use, other you still send unencrypted every time they access the data

[hellilyntax]

does it will slow down the page when viewing?
but, if its only milisecond, it doesnt matter...
im afraid it will took longer...

is there any way to decrypt before store in database?

[oldbear]

Hi

If you need to encrypt on the journey between PC and server, I'd suggest you look at IPSec. You can configure security by just enabling IPSec policies.

http://www.microsoft.com/technet/its...c/default.mspx

Also, SSL can be enabled through the network libraries in SQL Server.

http://support.microsoft.com/default.aspx?scid=276553

Securing data at the network protocol level is probably your best option, but you'll have to work with the sysadmin to get it implemented.

Cheers

[hellilyntax]

that means i dont need to encrypt the data myself right?

[oldbear]

That's right