Installing the PSQL Client for Windows
You must install the PSQL Client for Windows at the client machine itself; you cannot install it remotely from a server machine.
The PSQL Client is installed by default with PSQL Server, PSQL Vx Server, and PSQL Workgroup.
If the installation fails for any reason, the installation log file can be found in the Windows %Temp% directory.
The steps in this section explain how to install PSQL Client from its media using the default interactive installation.
*Note: See also Does it matter if I use PSQL Clients that are of a different version than that of the database engine?
►
To install PSQL Client for Windows
1
Launch the installation selection program from your Windows machine.
c.
Insert the PSQL CD into the CD-ROM drive of your Windows server, or run the downloaded self-extracting installer executable.
d.
If the installation does not start automatically, run the autorun executable from the operating system: drive:\autorun\autorun where drive is the drive letter of your CD-ROM device.
The installation selection dialog appears.
2
Click Client, which will install the components appropriate for your 32- or 64-bit Windows system.
The installer begins its initial preparation, after which the Welcome screen appears.
3
If prompted, close or uninstall any running applications that may interfere with the PSQL installation.
*Note: 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 PSQL installation if you ignore programs that may interfere.
4
At the Welcome screen, click Next.
5
Select the installation mode: Run as an Application (the default) or Run as a Service.
Figure 1 Client Cache Engine Installation Mode
 
Select Run as an Application if:
You plan to enable the use of Client Cache Engine and want the Client Cache Engine to auto-load as needed. After the Client Cache Engine starts, a tray icon appears, allowing you to control the Client Cache Engine from the Windows task bar.
Select Run as a Service if:
•
You run the Client on a machine within a Terminal Services environment or in a multi-user environment where fast-user switching is used.
•
You plan to enable the use of Client Cache Engine and want it to load when the machine starts.
*Note: Running the Client as a service requires the Log On as Service privilege. If you select to run the Client as a service under a user account other than the default Local System account, ensure that you modify the Log On Properties for the Service using the Windows Control Panel. If installed as a service, the Client cache service is set by default to auto-start. However, even though the Client cache service is running, an application does not use the Client cache unless the configuration setting for it is turned “on.” See the following.
The Client Cache Engine is a specialized version of the MicroKernel Engine that caches data for reading purposes and runs as a separate process. For simplicity, Client Cache Engine is often referred to as the “Client cache.”
By default, whether installed as a service or as an application, the use of the Client Cache Engine is disabled (turned “off”). “Off” means that nothing is cached on the Client side. READ requests from an application retrieve data from the remote database Engine. “On” means that the Client Cache Engine acts as an intermediary between the Client and the remote database Engine to cache data.
See Use Cache Engine in Advanced Operations Guide.
6
On the License Agreement page, read and accept the Software License Agreement, and then click Next.
7
Select the setup type: Complete (default) or Custom.
The Complete setup (recommended for most users) installs all the PSQL v12 components using the default options and locations.
•
If you choose a Complete install, click Next and continue with step 12.
The Custom setup (recommended for advanced users) allows you to specify the installation location.
•
If you choose Custom, continue with the following steps.
8
To specify different installation locations, click Change for any of the folders listed, click Change for any of the folders listed, then enter or browse for a different folder. Click OK to accept the location.
9
Click Next to continue.
10
Select the components and associated subfeatures you want to exclude from the installation and click Next. All of the PSQL components and subfeatures are selected for installation by default.
•
Data Access
•
ActiveX Interface Controls
•
ADO.NET Providers
•
Btrieve DOS (32-bit only)
•
DTO
•
JCL
•
JDBC Driver
•
OLE DB
•
PDAC
•
Utilities
•
Java Utilities
•
PSQL Control Center
•
Documentation
•
Data Definition File Builder
•
Other Utilities
•
Cobol Schema Exec
•
PSQL System Analyzer
11
Click Next to continue.
12
Click Install to begin installation.
13
Once the installation is complete, the final dialog of the Installation Wizard displays. Click Finish.
If you are prompted to restart your system, please do so to ensure proper operation of your PSQL product.
*Note: The installation program modifies some of the environment variables. On Windows platforms, environment variables are stored in the Control Panel under System information.