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.
asked 30 Aug '11, 06:24
You can use the
Alternatively, you could use the
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.
answered 30 Aug '11, 07:58