Home	Sales	Training	Contact Us
RDP Support		Open a Web Support Ticket Connect to Support with WebEx
RDPWin KB	RDP-DOS KB	IRM and IRM.Net KB	Crystal KB

Pervasive.SQL Database

Resort Data Processing 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 and installed by RDP to maintain a support contract.  Topics covered in this document include:

Pervasive Version 10 Installation Checklist

Pervasive.SQL Software Version 9 or Higher Required

12/3/2007 - RDP supports the current version of Pervasive versoin 10 and the prior version 9.  For existing customers, the upgrade to 9 or 10 significantly increases the performance of the system.  See RDPWin Version 2 for details.

Resort Data Processing (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 9 and higher. As a result all customers must use Pervasive Version 9 or higher by 1/31/2008 or the RDP SYSTEM WILL STOP FUNCTIONING.

To check your version of Pervasive, start the RDP-DOS or RDPWin system. The Pervasive Version appears on the login screen. If your version is less than 9.xx, you must call Rita Gale (970-845-1143) at RDP immediately to order an upgrade to avoid a system stop on 1/31/2008.

The table below summarizes the Pervasive Version requirements.

Also see:

• How to Verify Pervasive Version
• Install Pervasive 9.5 Service Pack 2
• RDPWin Version 2 Improves Performance with Pervasive version 9 or 10
• Upgrade Installation Procedures
• Order Pervasive by calling RDP Sales or download either Pervasive New User Order Form or Pervasive Upgrade Order Form.

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.

New Purchase
Pervasive.SQL Version 10 for Windows 2003/2008 Servers

Prices for a new (not an upgrade) Pervasive.SQL 10 in a Windows 2003/2008 server networking environment are listed below.  A few requirements to keep in mind when making your purchase:

• Windows 2008 server customers must run Pervasive Version 10, since Pervasive Version 9 is not compatible with 2008 servers. 
• Your purchase of Pervasive.SQL 10 platform of 32-bit or 64-bit must match your server (32 bits or 64 bits?).  Pricing is the same for each.
• Feel free to call RDP Support at 970- 845-7108 with any hardware questions. 

New customers must purchase the correct user count based on the table below plus a domestic shipping cost.  Outside Continental USA, please call for shipping prices.

The prices above also apply to adding additional users to an existing Pervasive.SQL V10 Windows 2003/2008 server.  For example, if you already have a 10-user Pervasive 10 and need 10 more licenses, the upgrade price is $1,195.  Pervasive Database Order Form for NEW Pervasive users.

Upgrade Prices from Pervasive V8.x to V10.x

The prices to upgrade from Pervasive Version 8 to Version 10 are below.  All customers with Version 8 or less must upgrade to Pervasive Version 10 by 1/31/2008.  RDP supports the current version of Pervasive (10) and one prior version (9).  Warning: RDP software will not start after 1/31/2008 unless using Pervasive 9 or higher. 

Also see:

• How to Verify Pervasive Version
• RDPWin Version 2 Improves Performance with Pervasive 9 or 10
• Upgrade Installation Procedures
• Order Pervasive by calling RDP Sales or Pervasive Database Order Form UPGRADING Pervasive customers.

Pervasive Upgrade Prices from Versoin 7 to 10

The prices to upgrade from Pervasive version 7 to version 10 are below.  All customers with version 8 of less must upgrade to Pervasive version 10 by 1/31/2008.  RDP supports the current version of Pervasive (10) and the prior version (9).  Warning: RDP software will not function after 1/31/2008 unless the Pervasive version is 9 or higher. 

Also see:

• How to Verify Pervasive Version
• RDPWin Version 2 Improves Performance with Pervasive 9 or 10
• Upgrade Installation Procedures
• Order Pervasive by calling RDP Sales or Pervasive Database Order Form UPGRADING Pervasive customers.

Pervasive.SQL V10 For Windows 2003/2008 Server

All RDP systems, even single-user systems, require a Windows 2003/2008 Server as the data server.  Systems with 1-10 users should purchase the 10-User New Pervasive.SQL V10 For Windows 2003/2008 Server.  See RDP Hardware Requirements for details.

Pervasive's website offers the following link for Error 1918. Error Installing ODBC driver.

Domestic Delivery Charge of $35.00

There is a domestic delivery charge of $35.00.  Please call RDP Sales for shipping information outside the continental United States.

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 10

Upgrading to Pervasive version 10 can be done without calling RDP support.  Customers using a Windows 2008 server must run Pervasive version 10, since Pervasive version 9 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.

1. 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.
   
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.
   
   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.
   
   
3. 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). 
   
4. Click File then Save As, and navigate to the RDPNT/RDP/Pervasive folder and save the document as PervasiveLicenseKey.txt.
   
5. 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.
   
   
6. Create ODBC connection for RDP.  Pervasive's website offers the following link for Error 1918. Error Installing ODBC driver.
   
   
7. 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.
   
   
   
8. 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 Workgroup Version 10.
   
   
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

Novell NetWare Data Servers

As of 1/1/2002, RDP stopped supporting Novell NetWare.  All RDP customers currently using Novell NetWare data servers should convert to a Windows 2003 data server as soon as possible.  See Six Reasons to Convert from Novell or Windows NT to Windows 2003/2008.

Workstation Operating Systems
Require Windows XP Professional and All Service Packs

RDP's property management system and the Pervasive.SQL V10 database require all workstations (clients) to use Windows XP Professional or Windows Vista (Business or Ultimate). 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 Version 10 and Citrix Software (Remote Connections)

The RDP property management system can be accessed by remote locations using Citrix software or Windows 2003 Terminal Services.  Each workstation connected to a Citrix or Windows 2003 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 10 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 | PSQL10 | 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:

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:

• Installation of Current Pervasive Client on the IRM Server
• How to Verify the Version of Pervasive Engine on the RDP Data Server 
• Order Pervasive by calling RDP Sales, or you can access the Pervasive Database Order Form for new Pervasive customers and upgrading Pervasive customers.