Hello there. I have read the server admin guide and tried to figure out what words to search on here because this is such a basic question. I installed Servoy on windows XP (pro sp2) and checked the box to install the application server as a service.
Developer launches fine as an app. I know the database service is running too because I can click the button to launch one of the sample solutions in client. And the repository button is there in the systray
But in many places in the docs and in posts i’ve read here it is recommended to be sure to stop the database service before doing certain things. if I click on the systray icon for the repository server and choose About a window opens up saying Adaptive Server Anywhere Network Server Version 9.0.2.2451. So the ASA is certaintly running as a service.
Yet when I visit the services control panel there is no ASA service listed. Not under “ASA” or “Adaptive” or “Sybase” and I really looked through the whole list.
I realize i cou7ld click the systray button and choose Exit, and I also saw the instructions in the guide for creating a database service, but I am confused as to why the service (even though i did not create one using sybase central) does start up (via develloper)_ but does not show up in the cp and am trying to understand servoy technology better.
Is it possible that if the service is only started by opening developer it is some kind of application specific service embeded into servoy and that’s why i don’t see it in the overall services cp?
Or what?
Sorry to ask such a basic question, but i’ve already spent two hours looking through the docs and the web and can’t find my answer by myself.
Thank you for your explanation marcel. before this i never saw a database being accessible to a client application without being hosted as a service, and so it was (and still is) a little confusing. So it seems like servoy developer application can “run” (as you say) the database as a service to its own client application without the database running as a service in the actual system. It seems a bit contradictory to the new user because not only the repository is available but also all the data stored in the databases is also available. I had thought “repository server” indicated that servoy is serving onLy its own repository database and not the data.
I do understand that the servoy can use other databases and that is one reason i’m trying it out. I wonder if i used mysql or something else for the back end and did not host the mysql service, would servoy client see the mysql data when developer is running the same way that client sees the asa data… (this is just being curious i don’t need that information for my work today of course)
so. now I know. the repository server will make the data available but i guess only locally and maybe only if the repository server is the default asa.
and to really host the solution i should create a service.
Servoy developer and server need a repository yes.
But this can also be served from another database.
When you use ASA, Servoy developer (and NOT server) will start up the database itself.
In ALL other cases you need to create a service (windows) or startup script to get the database up as you like it.
ok now I understand! ASA is a “special case” with servoy, embedded and so more automatic/easy to get going with it. Pretty soon I’ll try using a different dbms than asa for the back end to learn the differences really well. And then i’ll change the repository dbms too to learn that impact.
thanks for explaining so well. And I see many very intersting products on your web site.
When the red “SQL” icon appears in the Windows system tray Sybase is running as an application not as a Windows service. When it is running as a service no icon will appaer in the system tray.
Click the link below to see the contents of our bat file that closes Sybase if it is running as an application and then opens both Sybase and Servoy Application Server as Windows services:
if you run Sybase as a service, the red/yellow icon is also shown!
It depends on how you configure the service. By default a service is told to not interact with the desktop and it doesn’t show any icons. It is however possible to allow it to interact with ‘a’ desktop. Obviously on a server the question is always: what is ‘the’ desktop? In the classic Windows paradigm it is the monitor hooked up to the physical server but in todays modern environments definetely not: you have users, desktops and GUI’s completely separated from each other. Essentially: if you configured the service such that it can interact with the desktop and you only happen to have one GUI session with that particular desktop you might see an icon, in all other cases and combinations you won’t.
