Pervasive Work Group Engine Must Be Installed and Run as a Service
on Citrix or Terminal Server
Added 3/30/2006 - Article ID#: KWin0020
It is possible to access RDP from remote locations
using the Internet. For example, the reservation department could be in a different location than the property.
Remote workstations have access to all system functions and reports.
Remote access is accomplished using a Citrix or Microsoft Terminal
Server. Please see:
RDP uses the Pervasive.SQL
database, which includes a server component installed on the RDP data server
and a client component installed on all workstations. The Citrix or
Terminal Server requires installation of the Pervasive Work Group
Engine (Not the Pervasive Client) and must be run as a
service using the steps below. If not installed as a service, it is
possible for an administrative user on the Citrix or Terminal Server to close the Pervasive
Work Group Engine, which will cause all other users to hang while using RDP. If a user with administrative rights disconnects from the Terminal
Server, the message is:
"Remote
and/or local applications are active and connected to the Pervasive
database. Use the Pervasive Monitor Utility to view all users. If
you choose to continue shutting down, applications will fail with unpredictable
results"
Upgrade to Current Pervasive Version
When troubleshooting any problem with the Pervasive Database, the first step
is always to verify the version of the Pervasive Engine that is installed on the
Data Server and the version of the Pervasive Client on the problem
workstation. If either the engine or client are not current they
must be updated. See "How
to determine the Pervasive Version".
Upgrade Steps for Pervasive Version 10.xx
Upgrading to Pervasive Version 10.xx can be done without calling RDP support.
Customers using a Windows 2008 server must run Pervasive Version 10.x, since
Pervasive Version 9.x does not work on 2008 servers.
Note: All users must exit RDP during the upgrade,
including the IRM and all interface workstations.
Schedule this installation at a time when the system can be down for
approximately 4 - 8 hours AND when RDP support is open. RDP 24-hour
support is not available for Pervasive Updates.
-
Hardware Requirements: Workstations must be Windows XP with at
least one (1) gigabyte of RAM, and the data server must be Windows 2003 or
2008 with at least two (2) gigabytes.
- To install Pervasive P.SQL for Windows, you must have full
administrator-level rights on the machine where it will be installed.
This includes the Server and all workstations (Pervasive Client installations).
Pervasive Server Installation
- Uninstall prior Pervasive version. Customers should never install
an update over a prior version. Follow all steps listed in
Uninstall Pervasive which uses images
from 9.52 as a reference. Steps to uninstall should be the same
regardless of version. Be sure to reboot when the steps indicate to
insure the old version is removed correctly.
- Create a Pervasive folder in the RDPNT/RDP directory.
For example, with the F:/RDPNT/RDP folder selected, click File from the main
menu and select New/Folder. Enter Pervasive as the new folder name.
Copy the entire Contents from the PSQL installation disk into
the new F:/RDPNT/RDP/Pervasive folder. For example, select D:/ (disk
drive) from My Computer, select all files, right-click and select
Copy:
Select the F:/RDPNT/RDP/Pervasive folder, right-click and Paste the PSQL
disk contents into the newly created Pervasive folder.
- From the Start menu, select Run, enter "notepad", and click OK to open a
new Notepad document. Enter the License Key for your Pervasive
installation disk (located on the outside of the CD package).
- Click File then Save As, and navigate to the RDPNT/RDP/Pervasive folder
and save the document as PervasiveLicenseKey.txt.
- Follow all steps listed in Install Pervasive Server Version 10.
Be sure to reboot when the steps indicate to insure the old version is
removed correctly.
- Create ODBC connection for RDP.
Pervasive's website offers the following link for
Error 1918.
Error Installing ODBC driver.
- Navigate to the following location on your RDP Data server
C:\Documents
and Settings\All Users\Application Data\Pervasive Software\PSQL\samples.
Select the Samples.btr file and copy into your newly created RDPNT\RDP\Pervasive
folder. Do not copy the
Samples.btr file from the disk.
- Test connections.
Pervasive Client Installation (on all workstations and IRM Server)
- You cannot install the client remotely. You must physically sit at
each workstation and logon as a user with ADMINISTRATOR RIGHTS to the
workstation to install the Pervasive client, or to use RDPWin software.
The Pervasive client software must be installed on all workstations, the IRM
server, and all Terminal/Citrix Servers.
- Map a drive from the workstation to the RDPNT folder on the data server
- If a previous version of Pervasive Client is on the workstation, uninstall
it and then reboot the workstation.
- Install Pervasive Client Version 10 or
Workgroup Version 10.
- Test connections (using
specific Client configuration instructions).
- Repeat the uninstall steps for the old version and the installation
steps for Version 10.x for each server (including the IRM), interface
computers, and RDPWin workstations.
NOTE: The PSQL Workgroup engine is only needed for installations
where a single user workstation will be running RDP. All other machines
including the IRM, interface computers and RDPWin workstations can run on the
PSQL V.10 client (service) installation
See also:
Solution - Install Pervasive Work Group Engine as a Service
The solution to this problem is to run the Pervasive Work Group Engine as a service on
the Citrix or Terminal Server as follows:
- This procedure must be preformed from the Citrix or Terminal Server
console
- Install the Pervasive Work Group Engine using the Add/Remove Programs option in the
control panel. It is critical to use Add/Remove Programs to place the system into
"Install" mode which will assure that
all registry keys are placed in the correct location.
- Download PVSW.exe
from the ftp.resortdata.com site
and save the file to the Pervasive installation folder, usually C:\PVSW\Bin.
- Select Start-Run and locate the PVSW.exe in the bin folder and double
click the file to run the utility
- From the menu select Tools | WGE as Service
- In the dialog box, select the Install Service button. A dialog should be
displayed confirming that the service is installed and has been started
- Exit the PVSW program
- Reboot the Citrix or Terminal Server
- Start RDPWin from the Citrix or Terminal Server to verify that Pervasive
has been correctly installed as a service. There should not be a
Pervasive Engine icon in the taskbar
- Connect to the Citrix or Terminal Server and verify that remote
workstations can start RDPWin. Please see Using RDP Remotely with Citrix or Terminal Services on Windows 2003
NOTE: When
installing an upgrade to the Pervasive Work Group Engine, stop the service
before installation of the upgrade. To do this, either stop the service
using the services option in Administrative Tools or by using the PVSW utility. Once the upgrade has
been completed, restart the service or reboot the computer.
Links Related to Remote Access with Citrix or Terminal Server
Warning: There are special steps
required to install Pervasive on Citrix or Terminal Server. See
Pervasive Work
Group Engine Required, Run as Service on Citrix/Terminal Server.
The work group engine can be purchased from RDP for $100 by
calling RDP Sales.
