Instructions
Client/Server is more secure and is much less prone to data corruption. Only the server accesses the data so if it is in good working order you will not see any data corruption. The workstations access it only via the server.
To set up Client/Server:
- You need the client/server software from the following link. Run it on your server.
http://www.mailware.com/pub/MWCSEngine.exe
You will also need the Database System Utilities from the following link. Run this install on your server as well:
http://www.mailware.com/pub/Mailware2005DatabaseUtility.exe
- Next, create a directory on your server and share it. Use Notepad to create a clientserver.ini file with the following text and save it in that folder.
[Settings]
UseClientServer=1
IPAddress=127.0.0.1
Port=12005
HostName=
Service=
[Comments]
//Store this ini file in the directory that contains the reports and tools directories
//Set File>New Company on each PC to the same directory
Note: Change the IP address to the one on your host PC. To check your IP address, click the Windows Start button then choose Control Panel (you may need to select Settings, then Control Panel). Double click Network Connections. In the dialog that opens double-click your network connection. In the dialog that opens click the Support tab which displays your IP address (Note: this is the IP address for the PC, not necessarily its IP for the Internet.).
- You will also need to copy your reports folder from your current data directory (if you need help locating your data directory please visit http://www.mailware.com/quicktip002.htm) to this new folder.
- On your server, click the Windows Start button and select All Programs>DBISAM Additional Software and Utilities>Server Administration Utility.
- In the window that opens choose File>Login to Server. When prompted enter Admin as the User Name and DBAdmin as the password.
- Click the Server tab. Change the following:
- Click the Databases tab and then the Add button. In the Name field that appears type Mailware. Browse to the directory that contains your Mailware data, then click Save (Note: You must name the database Mailware).
- Click the Users tab and add as many users as you wish.
- Click the Database Users tab and then click Add at the bottom. Select one of the users you added from the pulldown that lights up. Check all the Rights to Grant and click Save. Repeat this for all users.
- Close the Server Administration Utility.
- Run Mailware and click File>New Company from the text menu. Give the company a name and browse to the directory that contains the clientserver.ini file. Click OK. You must do this at each PC in your network that runs Mailware. You can switch between your old company (which is direct access to the database) and the client/server company anytime you wish. In order to ensure client/server is running exclusively (and thus verify the database errors are due to network trouble) everyone must be pointed to the client/server company. Please be careful when testing that not a single pc is directly linked to the database. You may wish to remove sharing on the data directory temporarily to ensure this.
- To log in at each PC choose File>Open Company and select the new company. You will be prompted to enter your User ID and password you created in step 7 above. If you have Mailware security turned on you will be prompted to log in to Mailware as well. If you are not prompted to log in to client/server try using File>Open Company and selecting the new company again.
Client/Server Note: If you are using the Client/Server option for Mailware your Network Database will point to a folder that contains your clientserver.ini file and your Reports and Tools subdirectories. Your data is not located in this area and may not be accessible from individual workstations (depending on how your network was set up). Also, the Backup option from the Tools menu will not work through the client/server network database. You must link directly to your data directory to use the Backup option. |