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:
   
   
   • 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.