Stop SQL Anywhere when stopping Developer

By default when you close Servoy Developer it does not stop SQL Anywhere, this is on purpose and in many cases the way you expect and want it to work. However:

If, just like me, you have more than 10 Servoy installs, once in a while you will forget to shut down your iAnwyhere while switching to a different install, sometimes causing unexpected repository upgrades, etc. Solution: tell SQL Anywhere to shut down when you shut down developer.

Simply add the following option to the first line of your sybase.config (in sybase_db):
-ga

With this option SQL Anywhere will shutdown when all connections to that database are closed

Comments (3)

John Allen 2007-08-21

Hi Jan, I remembered this post and after hunting around for awhile I found it again. For me though it isn't working. After reading the documentation I thought it might be because it says that it actually only shuts down the 'personal' server (I think that means just 'dbeng9' not 'dbsrv9'). I changed the line in the properties file thinking I'd experiment with that but dbeng9 doesn't shut down either with the -ga flag. This is on a Mac G5. This works for you? Maybe I'll post something to Jose Ramos over at iAnywhere if you've had it working because it certainly isn't shutting down on my set up. John

Jan Aleman 2007-08-22

-ga should definitely work with dbsrv9, make sure to put it in the right place though or it will not work. Try for example putting it as the first option.

John Allen 2007-09-15

Yep. Putting it first did it. Thanks!