on 2015 Mar 02 2:57 AM
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
Request clarification before answering.
See the answer to the question How to limit the remote access to the database server? here on this forum.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
call sa_server_option('ConnsDisabled', 'YES')
or
call sa_server_option('ConnsDisabledForDB', 'YES')
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
30 | |
10 | |
8 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.