Hi. Is it possible to deny all new connections temporarily in SA12 and/or SA16? This would be great for updating the schema and debugging. br, Bjarne Anker Maritech Systems Norway asked 02 Mar '15, 02:56 Bjarne Anker Volker Barth |
You can do that via the system procedure sa_server_option when setting the options "ConnsDisabled" or "ConnsDisabledForDB" to YES, i.e. with something like
or
and reset them to 'NO' afterwards. Confine that very old FAQ here including sample code: Sample code: How to get full control over a SQL Anywhere server answered 02 Mar '15, 03:18 Volker Barth |
See the answer to the question How to limit the remote access to the database server? here on this forum. answered 02 Mar '15, 03:19 Martin |