This chapter provides instructions for installing and upgrading the DATABridge Client software on a Windows system.
If you're installing for the first time, complete Part 1 of this section. If you're upgrading, complete Parts 1 and 2.
Part 1: Install the Client (Windows)
Use this procedure for first-time installations and upgrades.
To install the Client
1 If a previous version of the DATABridge Client is running on your system, stop it.
2 From the DVD or DATABridge installation image, open the Windows32 (for 32-bit systems) or Windows64 folder (for 64-bit systems), and double-click the setup program (Setup.exe).
3 Accept the license agreement and click Continue.
4 Click the Feature Selection tab.
5 Next to the database client you want to install, click the menu and select Feature will be installed on local drive.
A disk icon appears next to each of the items you want to install. By default, the installer creates the install directory in C:\Program
Files\Attachmate\DATABridge\6.1. You can specify a different location on the File Location tab.
6 Click Install Now.
The installer copies files to the hard disk. This location is saved as the INSTALLDIR string value for the Windows registry key
“HKEY_LOCAL_MACHINE\SOFTWARE\Attachmate\DATABridge Client\6.1”.
7 In the updatepath dialog box, type the full filename for the Client working directory (such as D:\databridge or D:\databridge\work), or accept the default location.
Caution: Do not use the Program Files directory as a Client working directory; this will cause problems with Windows 7, Vista, and Windows Server 2008. If you install the Client to the default location, make sure that you understand how Windows treats spaces in directory names.
8 In the updatepath dialog box, select one of the following settings:
38 DATABridge Installation Guide
This setting Does this
Do not add DATABridge program directory to the PATH
Requires that you manually add the Client directory each time you run dbutility. Choose this option if you use scripts that specify the full path from which to run to run the client.
Add DATABridge program
directory to System PATH Adds the DATABridge Client directory to the Windows Path environment variable and makes the DATABridge Clientdirectory and the Client programs available to anyone who uses the computer.
Add DATABridge program
directory to the User PATH Makes the DATABridge Client and its programs available only to the user who installed the program. Choose this setting only if you run multiple versions of the client, different types of clients, or use scripts that specify the full path to run to run the client and do not add the DATABridge program directory to the PATH.
9 Do one of the following:
• If you're upgrading, proceed to Part 2: Upgrade the Client (Windows) (page 39) to complete the installation.
• If you're installing for the first time, install the Client Console. See Installing the Client Console (page 48).
10 When you've completed the installation, verify that the Client directory files are correctly installed. For a list of installed files, see Files Installed with the DATABridge Client (page 73).
Chapter 4 Installing the DATABridge Client 39
Part 2: Upgrade the Client (Windows)
Use this procedure to upgrade all versions of the DATABridge Client (6.0 and earlier). You must complete Part 1: Install the Client (Windows) (page 37) before starting this procedure.
To upgrade the Client
1 If you are upgrading from the DBLIB SQL Server client, you must create an ODBC data source in the Windows Control Panel, unless one already exists. Make sure to create a SYSTEM (not a USER) data source name.
2 Open a command prompt and type migrate. Type the full filename
enclosed in quotation marks if you didn't add the DATABridge program directory to the system PATH in step 8 of Part 1: Install the Client
(Windows) (page 37).
The migrate program creates a new Client working directory. Next, it creates a working directory for each data source being migrated and moves the existing user scripts and configuration files to this directory after updating the configuration file parameters. It also creates the service configuration file which contains any scheduling information defined for the individual data sources.
3 The program asks if you are upgrading from version 6.0 and were actively using the service. If the answer is yes, enter the full filename of the 6.0 Client working directory. The 6.0 and 6.1 working directories must be different. If you try to use the same directory, migrate will return an error. Your 6.0 data sources will be migrated to the new Client working directory structure. Skip steps 4-5.
4 When prompted, enter the name of each data source and the location of the working directory for this data source (either as a full filename including the drive letter or a name relative to the current directory, starting with a directory name).
5 Repeat step 4 for each data source. When you're done, enter an empty data source name, (that is, <CR>).
The migrate program creates a working directory for each data source.
The existing configuration file is used to create a new binary
configuration file in the config subdirectory. Deprecated parameters are removed or replaced by the equivalent parameters. User scripts are moved to the scripts subdirectory. Then, the migrate program starts the dbfixup program, which upgrades the client control tables and populates the dbscripts directory for each data source.
If the read_null_records parameter is set to true, the migrate program copies the Null Record files for the data sources to the config
subdirectories. A new configuration file is created (dbcontrol.cfg), which includes updated data sources and any existing scheduling parameters.
The migrate program runs a dbutility generate command for each data sources to populate the dbscripts directories.
40 DATABridge Installation Guide
6 To use the service to run the Client, install the Client Console. See Installing the Client Console (page 48).
Note: If you need to re-run the migrate program for any reason, first delete the Client working directory created by the migrate program