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,

asked 30 Aug '11, 06:24

Takudzwa's gravatar image

Takudzwa
818813
accept rate: 0%


You can use the encrypted clause with the unload select statement to create an encrypted file containing the data, but your client will need to use the load table statement to decrypt the data. This means that the client will need a full installation of SQL Anywhere.

Alternatively, you could use the unload select statement to create the file, and then use some non-SQL Anywhere technology to encrypt the file.

permanent link

answered 30 Aug '11, 07:59

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371109
accept rate: 52%

edited 30 Aug '11, 08:01

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.

permanent link

answered 30 Aug '11, 07:58

Volker%20Barth's gravatar image

Volker Barth
30.0k294448654
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×33

question asked: 30 Aug '11, 06:24

question was seen: 1,193 times

last updated: 30 Aug '11, 08:01