NesterSoft

Client-Server setup

WorkTime

More about

Download & Order

Help & Support

How-to Articles

Client-Server setup

Screenshots

Folders and Paths

Using on Wine

Support

How to Setup WorkTime to work in a client-server mode

WorkTime can work in a client-server mode: it means, that all client WorkTime application(s) store and access data at single separate computer (database server).
To run WorkTime in a client-server mode, you need to install Firebird database server and WorkTime database on your server PC; also you need to configure WorkTime client application(s) to use the server database.

You can use as a server any Windows PC in your local network. (Dedicated server is not required - you can run WorkTime on that PC as well.)

To setup your server follow these steps:
1. Download, install and run database server Firebird 2.1.
1.1. Direct download link here. Mirror on the NesterSoft web-site here (version 2.1.1.17910, size 6,659,927).
Also you can download latest version from the official Firebird web site - choose item "WIN32 - Windows executable installer for full Classic or Superserver"
1.2. Installation is very simple: you don't need to change any options, just click Next, .., Next, Finish.
See screenshots (also more information about Firebird) here

Note: If there is a firewall on the server machine - make sure port TCP/3050 is enabled.

2. Install WorkTime on the server PC (e.g. default location C:\Program Files\WorkTime).
If you are going to use WorkTime on the server PC - setup it as described below.

Note: Database file (wt4.fdb) must reside on a hard drive that is physically connected to the host machine - not on the filesystem share or a network filesystem. Also, it cannot be placed on a subst-ed or mapped drive.

Note: If you do not want to install WorkTime on the server - you can manually copy WorkTime database file (located in "C:\Documents and Settings\All Users\Application Data\NesterSoft\WorkTime\db\WT4.FDB" ) to the server - e.g. "c:\worktime\wt4.fdb".
Before copying make sure that WorkTime is not running - database file can be locked.

To setup WorkTime client computer(s)
1. Setup all WorkTime client applications (including WorkTime installed on the server, if any) to connect to the server:
Select Options menu item, Database tab, click Change Database and enter server name or IP address (here it's SERVER_PC) and local database path (here it's c:\WorkTime\wt4.fdb), click OK to save changes.

Note: Local database path means server's local relative path - where the file is physically stored on the server.

That's it, now WorkTime uses server database for storing data.

Troubleshooting

If WorkTime cannot connect to the server with the message
Unable to complete network request to host "SERVER_PC".
Failed to establish a connection.
unknown Win32 error 10060

1. Make sure that you have Firebird server installed and started on the SERVER_PC computer
(check Control Panel - Firebird 2.1 Server Manager applet)
2. Disable your server firewall or add entry to allow communications on port TCP/3050
3. Check your antivirus software to make sure it doesn't blocks network communication
4. Check that server name is resolved correctly (or use IP address)

Download WorkTime

Buy WorkTime


	(C) 1999-2009 NesterSoft Inc.