Home RDP Sales Contact Us Training  
RDP Support      Call (970) 845-7108        Open a Web Support Incident
RDPWin
Knowledge Base		 RDP-DOS
Knowledge Base		 IRM and IRM.Net
Knowledge Base		 Crystal
Knowledge Base
         

Updated: 3/31/08 SS

Pervasive V 9.5 Upgrade Procedure

Installing PSQL V9.50.077

Upgrade from Pervasive V9.1 to V9.52. 

Download the following files into a NEW Pervasive folder created as RDPNT/RDP/Pervasive:

Installation Procedures

Once the files are successfully downloaded, follow the steps for the server, client or work group, and the hot fix as listed below:

  1. Install PSQL V9.50.077 Server for windows RDPData server.
  2. Install PSQL V9.50.077 Client on any workstations using RDPWin and interface machines (other than the IRM).
  3. Install PSQL V9.50.077 Workgroup on any terminal Servers and the IRM.
  4. Install PSQL V9.52 Hot Fix on the server, IRM, interface and workstations.  This is the only file required for ALL machines.

All installation files should be downloaded and installed in a new folder created under RDPNT/RDP called Pervasive.

Installing PSQL v9.50.077.002 Server for Windows

  1. If it does not already exist, 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 name.

    Copy the entire Server folder from the PSQL installation disk into the new F:/RDPNT/RDP/Pervasive folder.  For example, select D:/ (disk drive) from My Computer, select the Server folder, right-click and select Copy:

    Select the F:/RDPNT/RDP/Pervasive folder, right-click and Paste the Server folder into the newly created Pervasive folder.
    You must be logged on to the Data server as the Administrator.
  2. Navigate to RDPNT/RDP/Pervasive double-click on the Pervasive PSQL v9.50.077.002 Server for Windows file.
  3. Accept the License Agreement.
  4. Enter your license key.
  5. Select Complete as the set-up type.
  6. Click through the remaining options taking all the defaults and complete the installation.
  7. Create your RDP01 ODBC Connection
  8. At the run Network Communication, Transactional and Relational Engine tests prompts:
    1. Check the box to Test active Installation and all three checkboxes:
      1. Test Network Communication
      2. Test transactional engine
      3. Test relational engine.
  9. To run Network Communications, enter the Target Machine (i.e., your RDP data server name).

    To run Transactional Engine tests enter the path to the PVSW\Samples folder. If Pervasive is installed on the D drive you may need to change the drive path.

  10. A message is displayed when the test is successful. In the case of a failed test, check the file path to confirm the location of the Pervasive\Samples folder.  If Pervasive is installed on your D drive you may need to change the file path above.
  11. Click Next to run Relational Engine tests.
  12. Enter the Server Machine Name such as RDPDATA and Engine DSN (this is your RDP01 directory). The RDP01 ODBC connection must be created in order for this Relational test to pass.  A message is displayed when the Relational test is successful.
  13. Click Finish to complete the Installation and register online if not yet done.
  14. Navigate to the C:\PVSW\Samples folder on the server and copy the Samples.btr file into the RDPNT\RDP\Pervasive folder created above.

Installing the PSQL V9.50.077 Client

The PSQL V9.50.077 Client must be installed on any workstations using RDPWin and interface machines (other than the IRM).

  1. You must be logged on to the data server as the Administrator.
  2. Navigate to RDPNT/RDP/Pervasive and double-click the Pervasive PSQL v9.50.077.002 Client for Windows file.
  3. Accept the License Agreement.
  4. Click Complete to do a complete client installation.
  5. Click through the options taking all the defaults and click Install when prompted.
  6. Once complete, you will prompted to run Transactional and Relational Engine tests.
  7. Check the box to Test active Installation including Network communications.
  8. Enter the Name of your RDP Data server.
  9. If the network communication is successful you will receive a message similar to below.
  10. To run Transactional Engine tests enter the path to your newly created RDPNT/RDP/Pervasive folder where the samples.btr file was copied (step 14 above).  If your RDPNT folder is mapped to a drive other than the F: drive you will need to alter the file path to the correct drive letter
  11. A message is displayed when the test is successful. In the case of a failed test, check the file path to confirm the location of the Samples.btr file.  The Samples.btr file resides on the data server in the C:\PVSW\Samples folder.  Copy this file into your \\Dataserver\RDPNT\RDP\Pervasive folder and run the test again.
  12. Click Next to run Relational Engine tests. 
  13. Enter the server machine name (i.e., RDPData) and Engine DSN (this is your RDP01 directory).  The ODBC connection must be created in order for this Relational test to pass. must be created in order for the Relational test to pass.
  14. A message is displayed when the test is successful. In the case of a failed test, ensure the ODBC connection is set up on the data server.
  15. Click Finish to complete the Installation and register online if not yet done.

Installing the PSQL V9.50 Workgroup Engine

  1. You must be logged into the IRM or Terminal Services Client as the Local Administrator.
  2. Double click the Pervasive PSQL v9.50.077.002 Workgroup file saved in your RDPNT\RDP\Pervasive folder.  The file will begin the setup process:
  3. At the prompt, click Next to begin the installation.
  4. Accept the License Agreement
  5. When prompted to install the program as an application or a service, select Service.
  6. Select Complete as the setup type.
  7. Click Next and Install.  If you receive an IIS Admin Svc. interference message, navigate to the IIS menu and stop the service temporarily.
    1. Go to Start -> Control Panel -> Administrative Tools -> Services.
    2. Find the IIS Admin service - right click and select Stop.
    3. Close the Administrative Tools menu and click Next.  When stopped you should see the service status as blank.
    4. The installation will proceed provided all conflicting programs have been stopped.
  8. Click Finish to complete the installation and register your product if not yet registered.
  9. Restart IIS Admin - Control Panel -> Administrative Tools -> Services Right click on IIS Admin and Start.
  10. At the prompts to run Network Communication, Transactional and Relational Engine tests, check the box to Test active Installation and all three checkboxes for Network Communication, Transactional Engine, and Relational Engine.
  11. Click Next to test the Network Communication click Next.
  12. Enter the name of the RDP data server and click Next.
  13. A message displays when the network communication test is successful.
  14. Click Next to Test Transactional engine.  Enter the path name of the RDP data server such as RDPNT\RDP\Pervasive folder.  This is where you copied the samples.btr file in the server installation.
  15. Click Next.  A message displays when the transactional engine test is successful.  In the case of a failed test, ensure the samples.btr file is in the RDPNT/RDP/Pervasive folder.
  16. Click next to run relational tests.
  17. Enter the RDP data server name into the Machine Name field, RDP01 into the Engine DSN field, and click Next.
  18. If you receive a failure message, review the ODBC connection instructions to ensure an ODBC connection to the RDP01 directory exists.
  19. Click finish to complete the PSA tests.
  20. You are now ready to run the PSQL V9.52 Hot Fix.

Installing the PSQL V9.52 Hot Fix

To avoid error messages during the Hot Fix installation, complete the following steps:

  1. Stop the PSQL services running on the Server by selecting Stop from the Start/Programs/Pervasive/PSQL10/Engines submenu.
  2. Log onto the workstation as the Administrator.
  3. Exit from all RDP applications.
  4. If on the IRM, IIS Admin must be stopped.
  5. If on the data server, stop the PSQL relational and transactional engine services in Admin Tools / Services.
  6. Copy the PSQL V9.52.exe into the new RDPNT/RDP/Pervasive folder.
  7. On the client or server, navigate to the Pervasive folder and copy the file to the desktop.
  8. Double-click to install.  The program walks you through the steps.
  9.  Accept the license agreement.
  10. Click Install, take all the defaults.

  11. Click Finish when complete.

  12. What to do in case of error messages:

    1. 

Home RDPWin RDP-DOS IRM/IRM.Net Preprinted Forms
Version 2.xxx Upgrade to RDPWin Link to Marketing Site Support: 970-845-7108
Training Vendor Interfaces Troubleshooting Sales: 970-845-1140