batfile to start Sybase and Server

Classic Servoy
1

Untill now I startup (and close) Developer to startup Sybase Database.
After that Servoy Server and Servoy Client can be started without problems.
I use the trick with Developer because I can not startup Sybase manually.

What Database, Server and options do I have put in (for use after a fresh install)?
What I really like to have however is a batfile to start up both Sybase and Application Server.
Does anyone have this code available?

Thanks,

Ron

Servoy 4.1.2 / XP SP3

2

Hi Ron,

what you have to do in order to get what you want is install both the application server and the database server as a windows service.
How this can be done is described in the Servoy Server Adminguide documentation, starting at page 45 and page 68.
http://www.servoy.com/docs/servoy_4/ServoyServer4AdminGuide.pdf

Then you simply could start the services manually by opening the windows service manager.
If this is one step to far, you could manually create a batch-file to start both services.
I’m not familiar with the dos syntax to start a service, but if you’ve succeeded in installing the services, I think Google can do the rest :wink:

Good luck!

3

Thank you Marc, I will try it the way you suggested.

Regards,

Ron

4

The DOS commands are like

net start <service<
net stop

where is the name used in the Windows service manager.

regards
Jan Willem

5

jw teunisse:
The DOS commands are like

Whoa I didn’t realize we also run on DOS ! :D

6

Hi all,

I still am not able to run servoy client after starting
Sybase manually.
(There is no problem if I startup Sybase with Developer)

This is what I did:

  1. Restart Windows XP.
  2. double clicked dbsrv10.exe
    Database in Server startup options points to:
    C:\Program Files\Servoy\application_server\database\servoy_repository.db
  3. Start Servoy Server
  4. Start Servoy Client
    Client window opens normallhy and then I select the crm app and get the following error:

ReferenceError: “gconst2_to_solution_preferences” is not defined. (openSolution#12).

Hope someone can help me out here.

Regards,

Ron

7

The databases that need to be started are specified in your servoy/application_server/sybase_db/sybase.config file, so you need to point to that when starting dbsrv10.exe.
Create a bat-file in your application_server folder containing:

start sybase_db\dbsrv10.exe @sybase_db\sybase.config

Now doubleclick that file to start the db. Does that solve your problem?

8

Yep, now it works.
Thanks very much Joas.

Regards,
Ron