Why doesn't a service entry appear under (Control Panel -> Services) when I start a SQLanywhere database? I have tried local database and network database. A lightning bolt icon DOES appear on the sys tray at the bottom right of the desktop, but no service entry.
The "about Sybase" help screen says "DEVELOPER EDITION". Is this the reason?
We have Windows server 2008.
asked 12 Dec '14, 11:55
Note that you can start a database server (as a service) without starting a database but when you do this you minimally need to give the database server a name using the -n server switch (i.e. placing -n before any database name on the command line makes it a server switch as opposed to a database switch, i.e. -n and a few other switches can act as either server or database switches depending on their placement on the command line).
Your application then needs to start a database by connecting to the utility_db (a pseudo database that exists on all SQLA servers) and then issues the START DATABASE ... statement. Alternatively your application can autostart the database on the server by including the database file name (relative to the server) in the client's connection string. E.g.:
Note that the connection string must contain the servername=... connection parameter so that the application connects to the correct database server (otherwise a database server will be autostarted)
answered 12 Dec '14, 14:47
The SQL Anywhere database engine will only appear as a Windows Service if you define it to run as such.
If you start the database engine "normally", it will run as a normal application under the currently logged-in user. It does not matter if you use a paid or a developer edition, and it does not matter if you use the personal engine (dbeng12.exe) or the network server (dbsrv12.exe).
The further doc topics may help to make SQL Anywhere run as a Windows service (here for version 12.0.1):
Note: It's rather common to stumble over the different notion of "Windows service" and "Database server", the latter means just that this is the program that "serves" the database for you, in contrast to the database files themselves...