The SQL Anywhere forum will be migrating to sqlanywhere-forum.sap.com on Saturday March 29, 2014. Existing questions, answers, comments, users, reputation, etc. will be retained and aside from some cosmetic changes there will be no significant change...
I'm having trouble connecting to a SQL Anywhere server. How can I fix this?
Note: This is the first in what I hope to be a series of articles covering frequently asked questions on this forum. The idea is to give generic and comprehensive answers t...
As of version 16.0 build 1690 and version 12.0.1 build 3994, SQL Anywhere uses OpenSSL to provide strong encryption routines. What impact will this change have for SQL Anywhere customers using strong encryption?
I was the original administrator of the forum. I did not write most of the original code for it but I did add some features (the tiered comments was me, and I added the SAP login stuff). I coordinated with Breck to import questions from the Stack Exc...
Other than the typo in the encryption algorithm '(AES256', your commands look OK, i.e.
SELECT CAST(DECRYPT(
ENCRYPT('toto', 'TheVeryLongKey', 'AES256'), 'TheVeryLongKey, 'AES256') AS LONG NVARCHAR)
does return 'toto'. This would imply that somewhe...
No, it's not complete yet but it really doesn't affect use of the forum. Once it's complete and we're ready to switch over, I'll schedule some downtime to do the move, and I'll add a new banner announcing that. I removed the banner because it doesn't...
It is safe to post. The backup of the existing machine is complete and the setup of the new machine is ongoing. Once it's ready to go, I'll have to take this site down again and do another backup of the SQLA database. Then I can move that backup to t...
All uploaded files are scanned by a virus scanner when they are uploaded. But this past weekend's system maintenance seems to have disabled the virus scanning software. I have a ticket open with SAP IT to get it re-enabled.