SQL Anywhere database - Programmatically stopping dbsrv9 on WM5

Author

Programmatically stopping dbsrv9 on WM5

Chris Castrianni

2005-12-22, 8:24 pm

Does anyone know if it is possible to programmatically
shutdown the dbsrv9 process (9.0.2.3228) on Windows Mobile
5.0 without loading a database into it first?

Since the dbstop utility does not exist on the CE variants,
I have been looking for a graceful way to programmatically
shutdown the database engine. I have tried sending its main
window a WM_CLOSE message, but if the main window is
minimized, it doesn't appear to support a windows message
loop. The only alternative of which I am aware seems to be
loading a database file into the engine just so I can turn
around and issue a "STOP ENGINE". Is this the best that I
can do?

Thanks.

Jarod

2005-12-24, 8:23 pm

Hello,

I start the dbsrv9 process with the "-ga" flag and when the last client
closes it's connection and shutsdown the dbsrv9 process shutsdown. I'm
using C# in my client application and the dbsrv9 does not actually
shutdown when I use the Close method on the connection object. Instead
it shuts down when my client program terminates. I've even tried
disposing and setting the connection to null before my application
terminates and the dbsrv9 remains open until my program really does
terminate. Hope this can help if you can't find a better answer.

Jarod

Sponsored Links