Install Pervasive Client Version 10 or 11

Added 1/22/08 SS
Updated 2/13/08 SS

See Pervasive for details on hardware, down-time, pricing, etc.  Ensure you are prepared with the following:

• Installation should be done while physically sitting at the machine and not logged in remotely or as terminal server.



• The user performing the Client upgrade/install MUST to be logged in with administrator rights.



• RDP recommends saving the Client install file to your RDPNT\RDP\Pervasive folder.  Copy this file onto the desktop of the local machine and execute, or place the Pervasive V10 installation disk into the drive and install using the original CD.



• The installation steps for Pervasive version 11 are relatively the same.

Client Installation Steps

1. Review all Upgrade Steps as set forth in the PVSW Upgrade Steps document.  When ready to perform Step 5 "Install Pervasive Client Version 10", continue with these Installation Steps.
   
2. Select "Install PSQL v10 Client for Windows (32-bit)" or for 64-bit based on individual customer needs.
   
   
   
3. At the InstallShield Wizard welcome screen, click Next.
   
   
   
4. At the License Agreement screen, select "I accept the terms..." and click Next.
   
   
   
5. Always choose "Run as Service".
    
   
   
6. From the Setup Type, select Complete and click Next.
   
   
   
7. At the Ready to Install the Program screen, click Install.
   
   
   
8. The Installation process may take several minutes as PSQL configures, copies, installs and deletes files.
   
   
9. When complete, click Finish.
   
   
   Continue on with the Pervasive System Analyzer Test 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. Create a new folder called Pervasive in the RDP folder (\\RDPDataServer\RDPNT\Pervasive)
2. Copy the Sample.btr file from ftp:\\public\pervasive into the new Pervasive folder.
3. Enter the Data Server machine name \\<dataserver>\RDNPT\RDP\Pervasive.
   
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 IRM or interface computer, enter 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:
   
   
   • C:\Documents and Settings\All Users\Application Data\Pervasive Software\PSQL
   • RDPNT folder
     
     
9. Click Finish.
   
   
   
10. When installing the Server version only, manually create the ODBC connections to the RDP Directories.

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