Home Software Sales Crystal KB Contact Us
RDP Support  


RDPWin KB IRM.Net RDPWin4 & PCI Compliance Search

Pervasive.SQL Database

RDP uses the Pervasive.SQL database from Pervasive Software, one of the fastest and most reliable client-server databases available. It has been in use for over 20 years at millions of sites worldwide.  Pervasive must be purchased from RDP to receive RDP support regarding the installation and upgrade process.  T

Click here for the Pervasive Version 11 Installation Checklist

Pervasive.SQL Software Version 11 or Higher Required

8/21/2014 - RDP uses the Pervasive.SQL database from Pervasive Software, one of the fastest and most reliable client-server databases available. We recently have improved the performance of our products by using the ODBC features of Pervasive Version 11. Pervasive Software only supports the current version of Pervasive.SQL, which is Version 11.   All RDP customers should make sure they are running version 11 or higher.

To check your version of Pervasive, start RDPWin.  The Pervasive Version appears in the system info section of the Welcome screen. If your version is lower than 11.xx, you must call Rita Gale (970-845-1143) at RDP immediately to order an upgrade.

Note: New and existing customers must purchase Pervasive from RDP. This purchase includes documentation and support of current Pervasive versions with the RDP programs.***

Count the Pervasive Users

Pervasive's database is sold based on the number of workstations (users) that simultaneously access the RDP property management system.  The minimum purchase from Pervasive is the 10-user Windows Server version.  When counting users, please include the following: 

  • The RDP data server, even if it will not be used as a workstation.
  • Each workstation accessing the RDP system on the local network.
  • All interface bridge workstations. When a bridge workstation runs multiple interfaces, it only counts as one Pervasive user.
  • Each Citrix or Terminal Services session.  Citrix and Terminal Services are software applications used for remote access.  For example, when there are five remote workstations connected to one Citrix server, this counts as five Pervasive users, not one.

Pervasive.SQL V11 For Windows 2003/2008 Server

All RDP systems, even single-user systems, require a Windows 2008 or 2012 as the data server.  Pervasive's website offers the following link for Error 1918. Error Installing ODBC driver.

Pervasive Installation or Upgrade Procedures

The Pervasive Database has a client component and a server component.  When upgrading, you should always uninstall the old version of Pervasive first (using Pervasive System analyzer), reboot, and then install the new version of Pervasive. 

Upgrade Steps for Pervasive Version 11

Upgrading to Pervasive version 11 can be done without calling RDP support.  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.

  1. Hardware Requirements:  Workstations must be Windows XP, Vista or Windows 7 with at least one (1) gigabyte of RAM, and the data server must be Windows 2003 or 2008 with at least two (2) gigabytes.
  2. 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

  1. 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.

  2. 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.
  3. 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.

  4. 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). 
  5. Click File then Save As, and navigate to the RDPNT/RDP/Pervasive folder and save the document as PervasiveLicenseKey.txt.
  6. Follow all steps listed in Install Pervasive Server Version 10 or 11.  Be sure to reboot when the steps indicate to insure the old version is removed correctly.

  7. Create ODBC connection for RDP Pervasive's website offers the following link for Error 1918. Error Installing ODBC driver.

  8. 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.


  9. Test connections.

Pervasive Client Installation (on all workstations and IRM Server)

  1. 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.
     
  2. Map a drive from the workstation to the RDPNT folder on the data server

  3. If a previous version of Pervasive Client is on the workstation, uninstall it and then reboot the workstation. 

  4. Install Pervasive Client Version 10 or 11 or Workgroup Version 10 or 11.

  5. Test connections (using specific Client configuration instructions).

  6. Repeat the uninstall steps for the old version and the installation steps for Version 10 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 10 client (service) installation

Pervasive Installation And Upgrade Technical Procedures
Purchase From RDP for Support Please order Pervasive from RDP Sales.  Pervasive must be purchased through RDP to maintain your sPervasiveOrderFormV10NewRDPCustomer.pdfupport contract and have installation assistance from RDP.  New Pervasive User Order Form.
All Users Must Exit RDP 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.

Note
: RDP suggests the upgrade/installation process be completed by a contracted or onsite hardware technician during regular RDP business hours.  Assistance with pervasive installations is not available during after-hours, 24/7 support.
Uninstall Old Version from Server Uninstall the old version of Pervasive from your data server.  All instructions to reboot must be followed.  This assures a clean, reliable installation of the new version.
Install Pervasive on Data Server Install the Pervasive Server Component on the data server.  This also installs the client version on the data server.
Verify Cache Allocation Verify the memory cache allocation is set to 20% of the total memory in the server using Pervasive Control Center.
Test RDPWin on Data Server Test to make sure RDPWin starts on the data server.
Uninstall Old Pervasive Clients

Install Pervasive 10 Clients
Uninstall the prior Pervasive client version from all locations where it currently exists including:
  • All workstations
  • The IRM server
  • All interface computers
  • All Citrix or Terminal Servers
Warning:  Do not upgrade the old client version to version 10 as many problems will result.  The correct procedure is always:
  1. Uninstall the old Pervasive Client
  2. Reboot (even if not prompted)
  3. Install the Pervasive version 10 client
  4. Reboot again (even if not prompted)
  5. Test to verify RDP functions

Workstation Operating Systems
Require Windows XP, Windows 7 or 8

RDP's property management system and the Pervasive.SQL V11 database require all workstations (clients) to use Windows XP Professional, Windows 7 or 8.  RDP does not support clients running any version of DOS, Windows 3.x, Windows 95, Windows 98, Windows ME, Windows NT Workstation, Windows 2000, Linux, Unix, etc.  See RDP Hardware Requirements for more details.

Pervasive.SQL and Citrix Software (Remote Connections)

The RDP property management system can be accessed by remote locations using Citrix software or Windows Terminal Services.  Each workstation connected to a Citrix or Windows Terminal Server, either remotely or via a thin-client connection, requires one Pervasive license.  It is important to Install Pervasive as a Service on Citrix or Terminal Servers.

Pervasive Performance Tuning

A document authored by Pervasive instructs on Tuning Pervasive's Performance.  Pervasive Version 11 also offers this information in the documentation under the heading Performance Tuning.  The article makes several good points.  It can also be accessed on any computer where Pervasive is installed under Start | Programs | Pervasive | PSQL11 | Documentation.

WARNING:  Changes to the pervasive settings can be dangerous.  Do not make changes to these settings without the guidance of Pervasive or RDP Support.

Troubleshooting Pervasive.SQL Database

The following links may be useful when troubleshooting problems with Pervasive Software and Resort Data Processing.  The following support phone numbers are also available:

Cảm ơn
Pervasive Support: 800-287-4383
RDP Standard Hours Support 970-845-7108
RDP Support Home Page www.Resortdata.com/customers/Customer/htm

The current version of Pervasive is much faster and more reliable than older versions.  If the solutions below are not helpful, it may be necessary to upgrade to the current version of Pervasive.  Please review the following:


Hyperlink Pervasive Database Topic
Overview Overview of Pervasive Software Including Installation and Upgrade Procedures
Purchase How to Purchase Pervasive.SQL from Resort Data Processing
K000060 Verify the Pervasive Version
KWin0200 Pervasive Workgroup Engine Must Be Installed as a Service on Citrix Server or Windows Terminal Server
K000188 Delete Pervasive Users Without Administrator Rights
KI0009 Correct Stat 94 on the IRM Bridge Server - Change SAT Entries
K000186 Pervasive Versions 7 or Less Do Not Work and Are Not Supported by RDP
K000187 Correct Stat 171 in RDP-DOS, IRM, or RDPWin 
K000163 Install and Configure Pervasive.SQL Using Terminal Services - IRM Server and Data Server
K000057 RDP No Longer Supports Novell Servers (Netware)
K000055 RDP Requires All Workstations use XP Professional with Pervasive
Installation Installing Pervasive on a Windows 2000/2003 Server and on Workstations
K000053 Uninstalling Pervasive from the Data Server, IRM, or Client Workstation
K000189 Stat 46 with RDP000 or RDP910 Using Pervasive Version 9
Support Home  RDPWin4 & PCI Compliance Enhancement Requests Open A Web Support Ticket
Training 3rd Party Interfaces RDP Sales Website Contact Us

 Facebook     Twitter      LinkedIn   TODF