Introduction
In order for Window Book Inc. to provide more reliable data access and improve overall performance of its products, we are changing the data format used by our programs to Pervasive.SQL. Pervasive.SQL is a well-known and highly regarded SQL database engine. You can begin this process by installing the Pervasive.SQL Workgroup included on this CD.
Doing this installation is the first step in preparing your system for the new SQL-based products from Window Book. You can plan on reaping the benefits of data stability, reliability and improved performance that this data format provides.
For this installation you simply run the Pervasive.SQL Installation from the CD and then reboot the computer to enable the SQL database engine. Print out the documentation included on the CD to help with the installation. If you have an existing Datmail, Postmaster or Postal Package Partner, the installation program will automatically apply a product license key. For new users you will receive the key once you have purchased your Datmail, PostMaster or Postal Package Partner. Note: Administrative Rights are required to complete the installation.
Procedure:
1. Install Pervasive.SQL on the Server. The
installation is the same for both Network Server and Workstations.
2. Install Pervasive.SQL using the CD on each workstation.
Note that Administrative Rights are required
to complete the installation.
3. After you have installed the program on
a workstation, reboot the workstation to enable the database engine.
4. Configure Pervasive.SQL as a Permanent
Gateway on the Server (see instructions below)
5. Install the WorkGroup Engine as a Service (see instructions below)
Procedure for setting up a Permanent Gateway on 2-5 User Networks:
With Datmail/Postmaster 5.01 or higher or PPP 4.02 or higher installed
and running on the Server:
1. Run
the program from the Server
2. With
the program running
(for DAT-MAIL, you will need to launch the STATEMENTS side of the program
by clicking on the 3602 icon in order to create the .LOC file)
Right click on the following file in the program’s data directory*:
~PVSW~.LOC
3. Click
Properties -- make the file READ ONLY.
4. Close
the file.
This makes the Server the Permanent Gateway.
* to find out what your data directory is, click on Help; About; More About; Environment
If you don’t want to run the Dat-Mail, Post Master, or PPP Program from the Server, only run the data from the server:
1. Go
to one of the workstations and run the program.
2. With the program open edit the ~PVSW~.LOC file using Notepad in Windows.
3. Put in the Server machine Network Identifier -
(This can be found under Start=> Settings
=> Control Panel=> System => Properties => Computer Name in
Windows 2000).
4. Exit
and Save the file in Notepad.
5. Make
the ~PVSW~.LOC file READ ONLY by Right-clicking, then click Properties
and choose Read Only.
This makes the Server the Permanent Gateway.
We are recommending that you set up their Server to be the Permanent Gateway. However, this does not require that you do this step on the Server itself. The key to remember here is that what you are actually trying to do when setting up the Permanent Gateway is to edit the .LOC File to have the Server Name in it & then make it read-only. Making this file read-only will force the Server to always be the machine that serves up the data. This can be done from any machine, including a workstation because the .LOC file is located in the Data Directory of our program, which actually resides on the Server!
If you are running a network version of your Datmail or Postmaster 5.01 or higher or Postal Package Partner 4.02 or higher with 2-5 users we require that you set up the Server as the Permanent Gateway.
For more detailed information on configuring a Gateway and its advantages
go to: http://www.goldstarsoftware.com/gateway.asp
A tool that installs the Workgroup engine as a service is available on the Pervasive Component Zone web site. To download the tool, visit the following URL and select the "Toolbox - WGE as an NT Service." link.
After downloading the file:
1. Place the tool in the BIN directory where
your Pervasive files are installed.
2. Shut down your Workgroup engine.
3. Double-click PVSW.EXE to run the tool.
4. From the menu, choose Tools | WGE as a
Service.
The next screen provides the option to install the Workgroup engine as a service. Before you do so, click Info and follow the instructions provided.
For Larger network configurations (6 or more users) contact Window Book Inc. for special instructions.
More Information on installing
the Pervasive.SQL V8 Workgroup Engine
For more details on and a preview of the Pervasive.SQL V8 WorkGroup Engine installation routine on this CD: Browse the CD, go to the \PSQL85WGE\books directory and open the PDF named Getting_Started_WorkGroup.PDF section 4: 1-13 guides you through the installation routine and describes what to expect during the installation. Dat Mail, Post Master or Postal Package Partner users are not required to register the program using the HTML registration if it comes up at the end of the routine.
Note: For 6 or more users on a network the Pervasive.SQL Netware Client/Server installation with a 10-user license is required and included in the purchase price of your Window Book product.
The setup of Pervasive.SQL is somewhat different
on Novell networks. For
the best possible performance, we recommend purchasing the Pervasive 5-user
Client/Server installation for 1-5 users on a Novell network.
Options:
1. Set up a PC on the Network running Windows 2000 or higher as the Permanent Gateway. Although this will work, it is not supported by Pervasive and is less efficient than the Client/Server option. For more than one workstation, option 2 is recommended.
2. Purchase the
Pervasive.SQL Netware Client Server installation for 1-5 users. It is fully supported,
is easier to maintain, and guarantees the fastest, most efficient data
retrieval.
For costs on this option
please contact
sales@windowbook.com
Supported Environments:
You may install the Pervasive.SQL database engine in any of the following environments:
Windows NT 4 Terminal Server SP6a
Windows 2000 Terminal Server SP1
Windows NT 4 Terminal Server SP6a with Citrix MetaFrame 1.8
Windows 2000 Terminal Server SP1 with Citrix MetaFrame 1.8
Only one instance of the database engine may run on any terminal server platform. You cannot run separate copies of the database engine within two or more terminal sessions.
Installation:
To install Pervasive.SQL on a terminal server, you must be logged into
the terminal server as a user with system administrator rights.
Windows NT Server
Prior to installation, you must switch the terminal server to install
mode using the change user /install command. This ensures that the software
is available to all users after installation. When the installation is
complete, you set the terminal server back to runtime mode using the command
change user /execute.
Windows 2000 Server
Install Pervasive.SQL through Add New Programs (Start4 Settings4Control
Panel4Add/Remove Programs4Add New Programs). The operating system automatically
handles the changing of terminal server modes.