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
         

Install Pervasive Server Version 10.xx

Added:       1/22/08 SS
Updated:    2/06/06 SW

Upgrade Steps for Pervasive Version 10.xx

Upgrading to Pervasive Version 10.xx can be done without calling RDP support.

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 2000 or 2003 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.

See Pervasive for details on hardware, down-time, pricing, etc.

Installation Steps

  1. Review all Upgrade Steps as set forth above.  When ready to perform Step 5 "Install Pervasive Server Version 10", continue with these Installation Steps.  Installation can now be done via the copied files in your RDPNT/RDP/Pervasive folder or directly from the PSQL installation disk. 

  2. If installing from the copied files on the data server, choose the file Autorun.exe (located in the RDPNT/RDP/Pervasive folder on the data server).  When installing from the PSQL CD, selection of Autorun.exe is automatic.

  3. When selecting the version to install, always the 32-bit version.  RDP does not support 64-bit.  Install the Server version first, then install either the Client or Work Group (one, but not both) and accept all the default settings for file location etc.
     

  4. At the InstallShield Wizard welcome screen, click Next.

  5. At the License Agreement screen, select "I accept the terms..." and click Next.

  6. At the PSQL License Key screen, enter your License Key provided on the installation disk.
     

  7. From the Setup Type, select Complete and click Next.  The Complete setup (recommended for most users) installs all the Pervasive PSQL v10 components using the default options and locations.

  8. At the Ready to Install the Program screen, click Install.

  9. The Installation process may take several minutes as PSQL configures, copies, installs and deletes files.  This may take several minutes.

  10. When complete, click Finish.

  11. The Pervasive registration information opens in Explorer.  Registration can be completed at http://www.pervasive.com/registration at a later time.  Copy the file samples.btr on the dataserver from  "c:\Documents and Settings\All Users\Application Data\Pervasive Software\PSQL\samples" and paste it into the RDPNT\RDP\Pervasive folder. 

  12. Continue with the upgrade process by moving to the testing steps.

Test the Active Installation

Added:    12/20/07 SS
Updated:   7/03/08 SS per KW

  1. Select Pervasive System Analyzer from the Start - Programs - Pervasive - Utilities submenu.
  2. At the Pervasive System Analyzer welcome screen, click Next.

  3. From the Pervasive System Analyzer (PSA), select the "Test Active Installation" radio button. Check the boxes for "Test network communication", "Test transactional engine", and "Test relational engine" and click Next.
     
  4. At the Test Network Communication screen, enter the server name such as RDPDATA (no \\ necessary) to designate the target machine.  Do not enter the IP address, as this does not verify the DNS configuration.
  5. A successful test results in a message similar to that shown below:
  6. To complete the transactional tests,
    1. When testing the server installation, accept the default settings as shown below, including the default samples directory setting.  Click Next


    NOTE:  The RDPUsers Group must have full control to the PSQL folder in this location.  A mapped drive is not necessary; however, access to this folder is needed in order for transactional and relational engine tests to succeed.

  7. At the Test Relational Engine screen, select the "I want to run the relational tests" radio button and click Next.  To complete the relational test:
    1. On the Server, enter the Data server machine name.  For the Engine DSN, enter the RDP directory such as RDP01.


      When complete, the results of the test are displayed in a screen similar to that shown below:


      If the tests fail,  error messages are displayed as shown below.  This means you may be required to review DNS setup and ODBC connection setup.
  8. Once all three tests are completed successfully, view the log file.  Test failure may be due to user access rights to the data server Pervasive files. Check that all RDPUsers have full control to the following locations on your data server:

  9. Click Finish.

  10. When installing the Server version only, manually create the ODBC connections to the RDP Directories.
 
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