SQLAnywhere: Switch to choose between WATCOM and T-SQL

If you are still having problems with this, the first place to look is in the Windows Application Events log - you should see the reason (eg manual shutdown requested) why the server was stopped.

You can also get the database engine to write its own console log to file with the

-o <filename>

server start up option - that may give you more detailed information.

It's important to check that your connections aren't specifying the AutoStop connection parameter or the Stop Database After Last Disconnect ODBC setting. This only applies if you are asking the connection to automatically start the database engine if it is not already running - NOT if you are running the database engine as a service.

You don't say which version of SQL Anywhere you are using but for v12.0.1 you can execute SELECT PROPERTY ( 'ServerEdition' ); The result is explained in the docs thus:

ServerEdition

Returns a space-separated list of words describing the database server type. Values include:

Evaluation
Developer 
Web 
Educational 
Standard 
Advanced 
Workgroup 
OEM 
Authenticated

If you have a separate license for any of the following features, then the appropriate string(s) are added to the license string that is returned:

HighAvailability   See SQL Anywhere high availability option. 
InMemory           See SQL Anywhere in-memory mode option. 
ECC                See SQL Anywhere security option. 
FIPS               See SQL Anywhere security option. 

You can get more help at the dedicated SQL Anywhere forum http://sqlanywhere-forum.sap.com/