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.2.
1.1. Direct download link here.
Mirror on the NesterSoft web-site here
(version 2.1.2.18118, size 6,724,378).
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)
