If I start Servoy Developer, the Sybase-databases are launched automaticly (when they are not running)
When I start the Servoy Server (on win2000 under services) the Sybase databases are NOT launched.
Is it possible to add this somewhere in the wrapper-config file?
Or do I have to do something else?
We don’t know which databases are used by the servoy server so we start none.
Actually we did not want to start any db, but in that cenario Servoy developer is not running out of the installer (which seemed bad to us).
It is also far more efficient to start any database on system startup.
Can you point us to any documentation how the Sybase-databases must or can be started under Services?
[EDIT: Don’t follow the instructions in this post, use the ones in the lower post]
NOTE: instructions below are windows only
-Open Sybase Central
-Click mobilink server, services
-Click Add service
-follow the online instructions
For executable use:
c:\Servoy\sybase_db\dbsrv9.exe
(adjust path as necessary!)
for parameters use:
@c:\Servoy\sybase_db\sybase.config
(adjust path as necessary!)
Are there possibly any other steps required? I am not able to get this to work.
Are you getting any error then?
What data did you enter in the screens?
General tab is set to:
Type: Service
Service Type: Mobile Synchronization (can’t be changed)
Status: Stopped
Startup Type: Manual
Account is set to: Local system account/allow to interact w/desktop
Dependencies reads: ASANYMobiLink (no changes made here).
For the Configuration tab I tried the attached both with and without the “@” in the parameter.
Error message just reads: “There was an error while carrying out the operation. Please make sure the service is configured correctly.”
My wrong. My instructions were incorrect. After a bit more research here’s the correct way to do it.
(adjust paths as necessary)
C:\Program Files\Servoy\sybase_db\dbsrv9.exe
C:\Program Files\Servoy\sybase_db\sybase.config
C:/Program Files/Servoy/sybase_db/sybase_log.txt
and also for each database line entry:
database/servoy_repository.db becomes:
C:/Program Files/Servoy/database/servoy_repository.db
By default we don’t put absolute paths in the configuration file so that you can move your Servoy directory easily to another directory and/or disk.
If you also run Servoy Application Server as a adjust it’s dependency in the properties of the service so that it start after iAnywhere starts (listed as Adaptive Server Anywhere SERVICENAME in Services)
It is still not working. My Sybase.config file reads:
-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o C:/Program Files/Servoy/sybase_db/sybase_log.txt
C:/Program Files/Servoy/database/servoy_repository.db
C:/Program Files/Servoy/database/user_data.db
C:/Program Files/Servoy/database/example.db
C:/Program Files/Servoy/database/log_data.db
C:/Program Files/Servoy/database/crm.db
C:/Program Files/Servoy/database/contacts.db
C:/Program Files/Servoy/database/pdf_forms.db
I am not able to change the Servoy Application Server dependency in the properties of the service because it is grayed out. My Sybase Central settings are shown below.
Also, with the current settings I am not able to open Servoy developer. It gives me a “connection refused: connection” error.
Do you get any error messages in C:/Program Files/Servoy/sybase_db/sybase_log.txt ?
I will check it out when I get back in the office.
No, there do not appear to be any error messages in sybase_log.txt.
When I have the described absolute paths in the Sybase.Config file Servoy Developer will not open. When I revert back to the original Sybase.Config file Servoy Developer will open.
Clicking around a little within Sybase Central I see that when I right-click “Adaptive Servery Anywhere 9” there is an option to establish a connection. Should I first be making a connection there?
defer.jar (5.07 KB)
I have the same problems which are discribed by Westy
The services will not start!
Also, developer won’t start the Sybase-databases anymore.
Hi guys
we have followed these instructions also hoping to get servoy server working on our windows server..
we seemed to be having a similar experience to you Westy
not working so far…
also noticed the same problem you have with developer no longer working after making these changes…
we are going to try and undo the changes
I hope our input helps in some way
have others got servoy server working on windows 2000 using sybase?
thanks
eugene
Strange, it works perfect on my machines. I’ll try it out on a few more machines here to see if it’s just my machine that will do anything I instruct him.
I’ve done a bit more testing on Windows and my previous examples appear to have some problems when used with spaces in the filenames. Here’s a configuration that has been tested on multiple machines:
In Sybase Central in File name:
C:\Program Files\Servoy\sybase_db\dbsrv9.exe
(no quotes)
in Parameters:
"@C:\Program Files\Servoy\sybase_db\sybase.config"
(INCLUDING the quotes)
change your sybase config file to look like this:
-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o "C:/Program Files/Servoy/sybase_db/sybase_log.txt"
"C:/Program Files/Servoy/database/servoy_repository.db"
"C:/Program Files/Servoy/database/user_data.db"
"C:/Program Files/Servoy/database/example.db"
"C:/Program Files/Servoy/database/log_data.db"
"C:/Program Files/Servoy/database/crm.db"
NOTE: If you run iAnywhere as a service make sure to turn of the Startup launcher so that Servoy doesn’t launch a second copy of iAnywhere. Open Preferences from the edit many and delete the contents of the Startup Launcher field on the Designer tab.
NOTE2: If you create new databases don’t forget to restart the iAnywhere service after adding the new database to the sybase.config file.
Sorry Jan, but it still does NOT work
if I do this in Sybase Central Filename
“C:\Program Files\Servoy\sybase_db\dbsrv9.exe”
Sybase Central says: This file does not exist.
I must remove the quotes, before I’ll get any further.
I double checked everything, and I have everything the same now.
But if I start the services, I get the error:
Error 193 %1 is not a valid Win32 Application
HJK:
Sorry Jan, but it still does NOT workif I do this in Sybase Central Filename
“C:\Program Files\Servoy\sybase_db\dbsrv9.exe”Sybase Central says: This file does not exist.
I must remove the quotes, before I’ll get any further.I double checked everything, and I have everything the same now.
But if I start the services, I get the error:
Error 193 %1 is not a valid Win32 Application
You’re correct on the qoutes, the first one should be without quotes, the arguments with.
What happens if you try to use the command and arguments on a command prompt?
If I start dbsrv9.exe by hand and fill in by the options:
“@C:\Program Files\Servoy\sybase_db\sybase.config”
everything is starting fine.
Only if I want to make a service from Sybase Central, this goes wrong!
De services is made and when I run it (under services) I get the the error.
