Installing the Pervasive.SQL Workgroup Engine

Note
If the installation fails before the program copies any files to the target installation directory, the installation log file (install.log) can be found in the directory specified by the %TEMP% environment variable. This directory is often c:\windows\temp or c:\winnt\temp.

To install Pervasive.SQL 9 SP1 (9.1) on a Windows workstation

Launch the installation program from your Windows workstation:

Insert the Pervasive.SQL 9 SP1 (9.1) Workgroup CD in the CD-ROM drive of your Windows workstation.

If the installation does not start automatically, click Start, select Run, and type drive:\autorun\autorun where drive is the drive letter of your CD-ROM device.

The installation selection dialog displays.

Click the button for the "Workgroup" installation.

The installation program begins its initial preparation. After the preparation completes, the Welcome screen appears.

If prompted to reboot your machine, see Installation Tips regarding the Pervasive.SQL 9 SP1 (9.1) Setup Reboot Required dialog box.

Click Next to proceed with the installation.

Read and accept the Software License Agreement.

Figure 4-1 Pervasive Software's Software License Agreement

Read the Pervasive Software License Agreement. Select the choice that indicates you accept the terms in the license agreement choice.

Click Next to continue the installation.

During the install, a five-user license is automatically installed. See User Licenses for more information about Workgroup licenses.

Select the setup type: Complete or Custom

Figure 4-2 Setup Type Dialog Box

The Complete installation, recommended for most users, takes default actions for most operations performed during the installation. The Complete Workgroup installation installs the following components to drive C:

Pervasive.SQL 9 SP1 (9.1) engine, including the Transactional and Relational (ODBC) Interfaces

Pervasive.SQL Control Center

Utilities

Online documentation in Javahelp format

The Custom installation is typically for advanced users. It allows you to specify the installation location, select the components to install, and determine the space requirements for the components.

Click Next, then continue based on your choice of Complete or Custom:

If you choose a Complete install, continue with the next step.

If you choose a Custom install, skip now to Custom Installation Path .

At this point, if you want, you may click Back to change or review any of the installation settings, or click Cancel to exit the installation program. After you click Install, you may still exit the installation, but you will be unable to change or review settings.

Click Install.

If required, close any running applications that may interfere with the Pervasive.SQL installation.

A dialog box appears if applications are running that can interfere with the installation of Pervasive.SQL.

Figure 4-3 Detection of Programs Running During Installation

Decide how to continue with the installation. Your choices are:

To exit all of the programs that may interfere, then click Next.

Not to exit all of the programs that may interfere, then click Ignore.

Note
Next does not proceed with the installation unless you exit all programs that may interfere.

If you wish to leave one or more programs running that may interfere, you must click Ignore to continue. Unpredictable results may occur during the Pervasive.SQL installation if you ignore programs that may interfere.

If no running applications interfere with the Pervasive.SQL installation, the installation process continues. A dialog box appears that gives you a status.

Figure 4-4 Setup Begins Copying Files

Installation actions include, but are not limited to, the following:

Script operations

Component registration

File copying

Shortcut creation

System registry updates

Sample database creation

After the initial actions, the installation process launches the Pervasive System Analyzer (PSA) Wizard. The PSA Wizard allows you to test the transactional and relational interfaces. These tests ensure that your database engine is working as expected.

By default, the option for the transactional tests is selected.

Figure 4-5 Transactional Engine Test

Click Next to run the transactional tests and to see the results.

PSA performs a series of tasks to ensure that the transactional engine is working properly.

PSA displays a check mark for each test that passes and an X for each task that fails during the transaction engine test. A summary report is also provided in the information window, as shown in the following figure.

Figure 4-6 Transactional Engine Test Results from PSA

If any of the tests fail, see Chapter 12, Installation Troubleshooting.

Once your transactional tests are successful, click Next to proceed with the PSA Wizard.

PSA is now ready to ensure that the relational engine is working properly.

Figure 4-7 Relational Engine Test

Note that the tests use your current machine name and the sample demodata database. Use these values unless you specifically wish to test a different database. To test a different database, enter the Machine Name and Engine DSN for the engine data you want to test.

Click Next to run the relational tests and to see the results.

PSA displays a check mark for each test that passes and an X for each task that fails during the relational engine test. A summary report is also provided in the information window, as shown in the following figure.

Figure 4-8 Relational Engine Test Results from PSA

If any of the tests fail, see Chapter 12, Installation Troubleshooting. If you want to view the PSA log file, it is named by default PSALog.txt and is located by default at <OSdrive>\Program Files\Common Files\Pervasive Software Shared\PSA, where <OSdrive> is the drive letter where your operating system is installed.

Once your relational engine tests are successful, click Next.

The final dialog of the PSA Wizard displays and provides a summary of the tasks completed by the Wizard.

Click Finish to complete the PSA Wizard.

The final dialog of the Installation Wizard displays along with a registration page.

Pervasive Software recommends that you register your product to receive news about future updates, and other timely information. You can also register later using a web, e-mail, or print-based registration form.

Figure 4-9 Product Registration Page

If you did not read the README file prior to installation as described in Before You Begin , please do so now from the registration page.

Click Readme on the registration page to read the README file.

View the Readme file.

Close the Registration page (click the "X" in the upper right corner).

Click Finish to complete the Installation Wizard.

If installed files could not be copied because they were locked in memory, a reboot may be necessary at this point. Setup only prompts for a reboot if a locked file or some other event was detected that requires a reboot. Please reboot your system if prompted to do so in order to ensure proper operation of your Pervasive.SQL 9 SP1 (9.1) product.

Note
If you have any trouble with the installation, see Chapter 12, Installation Troubleshooting.

The install program modifies the PATH and CLASSPATH environment variables at the end of the installation process, if needed. These settings control how your Windows operating system finds Pervasive components. These variables are stored in the Control Panel under the Advanced tab on the System icon.

Thank you for choosing Pervasive.SQL.

What to do Next

Skip the next section for custom installations and see Common Questions After Installing Pervasive.SQL .