Encrypt Database Output

[Former Member]

Want to be able to select from a SQL Anywhere Database and output to a CSV file and encrypt that file and send it to my client who does not have sql anywhere but should be able to decrypt the file. So do i install SQL Anywhere Client on the client machine so they can decrypt or need a full SQL Anywhere insttallation.

Regards,

[VolkerBarth]

If you are refering to the ENCRYPT()/DECRYPT() functions, they are processed on the server and are only available by sending queries against the server.

So it won't help your customer to just have a SQL Anywhere client install available.

Cf. this FAQ where I have asked for client-side support of such encryption tasks...

---

Personally, I would simply use something like WinZip or WinRar to encrypt the files.