The following table shows the ODBC 3.5 driver installation directory.

Table 14-1 ODBC 3.5 driver (32-bit mode) installation directory

Note 1

The default Windows directory is C:\WINNT in Windows 2000 and C:\WINDOWS in other platforms.

Note 2

• Underline indicates the HiRDB client installation directory.
  

  Table 14-2 ODBC 3.5 driver (64-bit mode) installation directory

  Platform	Installation directory
  Windows Server 2003	Windows-directory
  Windows Server 2008
  Windows XP
  Windows Vista
  Linux	/HiRDB/client/lib/

Note 1

The default Windows directory is C:\WINDOWS.

Note 2

Underline indicates the HiRDB client installation directory.

The ODBC 3.5 driver installation flow is described as follows.

1. Installing the ODBC 3.5 driver
   Insert the provided medium and follow the installation procedure.
   
2. Installing the ODBC driver manager
   In the Windows edition, if the ODBC driver manager version is old, install the new ODBC driver manager.
   In the Linux edition, HiRDB does not provide an ODBC driver manager. Separately install an ODBC driver manager that supports ODBC 3.5 API and that can be run on Linux.
   
3. Setting data sources
   Set data sources.
   

(a) Installing the ODBC 3.5 driver

To install the ODBC 3.0 driver:

1. Execute hcd_inst.exe found on the integrated CD-ROM to start Hitachi Integrated Installer.
2. At the Hitachi Integrated Installer screen, select one of the following, and then click the Execute Installation button to start the HiRDB setup program:
   For Windows edition client products:
   
   • For HiRDB/Run Time: HiRDB/Run Time
   • For HiRDB/Developer's Kit: HiRDB/Developer's Kit
   For Windows edition server products:
   
   • For a HiRDB/Single Server: HiRDB/Single Server
   • For a HiRDB/Parallel Server: HiRDB/Parallel Server
3. Perform the following operation; the setup program for the selected program process starts:
   For Windows edition client products:
   From the Select Program Process window of the HiRDB setup program, select one of the following, and then click the Next button:
   
   • For HiRDB/Run Time: HiRDB/Run Time
   • For HiRDB/Developer's Kit: HiRDB/Developer's Kit
   For Windows edition server products:
   From the Select Program Process window of the HiRDB setup program, select HiRDB/Run Time, and then click the Next button.
   
4. When the Select Installation Destination dialog box appears, change the installation destination as needed and click the Next button.
5. In the Select Setup Type dialog box, select Typical or Custom, and then click the Next button.
6. If you have selected Custom in step 5, in the Select Component dialog box, select ODBC3.5 driver, and then click the Next button.
7. The ODBC 3.5 driver is copied under Windows-directory\System32.
8. The installation procedure is now complete.

(b) Installing the ODBC driver manager (which is included in MDAC2.6RTM)

If the version of the installed ODBC driver manager is old, you must download the most recent MDAC from the Microsoft home page and install it. To determine the version of the ODBC driver manager, start the ODBC Administrator and double-click the About the ODBC driver manager tab. If the driver manager version is 3.520.6526.0 or earlier, it is old.

(c) Setting data sources

To set data sources:

1. Start the ODBC Data Source Administrator.
2. Make sure that the tab item is User DSN and click the Add button.
3. When the Add Data Source dialog box appears, select HiRDB ODBC3.5 Driver and click the Finish button.
4. When the HiRDB ODBC3.5 Driver Setup dialog box appears, specify the necessary items.
   

   Data source name

   Specify a name identifying the data source. The name can have up to 32 single-byte characters or 16 double-byte characters. Single-byte and double-byte characters can also be mixed.

   PDHOST (host name)

   For a HiRDB/Single Server, specify the host name of the server machine on which the single server is located. For a HiRDB/Parallel Server, specify the host name of the server machine on which the system manager is located.

   If this item is omitted, the value specified for PDHOST in the client environment definition is assumed. For details about PDHOST, see 6.6.4 Environment definition information.

   PDNAMEPORT (HiRDB port number)

   Specify the port number (the value specified for the pd_name_port operand of the system definition) of the HiRDB server to be accessed.

   If this item is omitted, the value specified for PDNAMEPORT in the client environment definition is assumed. For details about PDNAMEPORT, see 6.6.4 Environment definition information.

   HiRDB client environment definition file name

   Specify the absolute path name of the HiRDB client environment definition file. Use this item to change the specification values for the HiRDB client environment variables for a particular data source. For example, if you are using the high-speed connection facility (PDSERVICEPORT) to connect to multiple HiRDB systems, you can use this item to specify the file name of the HiRDB client environment definition file and change the connection destination for each data source.

   If this item is omitted, HIRDB.INI is assumed.

5. Choosing the OK button returns the window to the User DSN tab, and the registered data sources are displayed.

• Stopping data source setup

To stop data source setup, from the HiRDB ODBC3.5 Driver Setup dialog box, click the Cancel button. When the Cancel button is clicked, no data source is registered.

• Deleting a data source

To delete a data source:

1. From the Data Source dialog box, select the name of the data source to be deleted.
2. Click the Delete button to delete the data source.

(a) Installing the ODBC 3.5 driver

Start the Hitachi Program Product Installer and install the ODBC 3.5 driver.

(b) Installing the ODBC driver manager

The Linux edition of HiRDB does not provide an ODBC driver manager. You must install it separately.

(c) Registering the ODBC driver information

You must edit the odbcinst.ini file in order to register the ODBC driver information.

This subsection describes an example that uses unixODBC as the driver manager.

The odbcinst.ini file is located in /usr/local/etc. The following example edits the odbcinst.ini file for using the HiRDB ODBC 3.5 driver for the 32-bit-mode edition of Linux.

Example

[HiRDBOdbcDriver] ..............................................1 Driver = /HiRDB/client/lib/libodbcdrv.so .......................2

1. Driver name
   Square brackets ([ ]) enclose the driver name that corresponds to the data source. You can specify any name.
   
2. Driver
   Specify the absolute path of the HiRDB ODBC 3.5 driver for the Linux edition. In 64-bit mode, it is libodbcdrv64.so.
   

(d) Setting data sources

Edit the odbc.ini file.

This subsection describes an example that uses unixODBC as the driver manager.

The odbc.ini file is located in /usr/local/etc. It also exists as a hidden file named .odbc.ini in the home directory. These two files correspond to the system DSN and the user DSN in Windows. If you edit the file as user DSN, place the .odbc.ini file in the home directory of the user who executes applications.

The following example edits the odbc.ini file.

Example

 
[HiRDB_LIN30] ..............................................1
Driver = HiRDBOdbcDriver ...................................2
PDHOST = 10.209.34.223 .....................................3
PDNAMEPORT = 22200 .........................................4
INIFLNAME = /usr/local/etc/HiRDB.ini .......................5
 

1. Data source name
   Specify a name identifying the data source. This name must observe the rules for the ODBC driver manager being used.
   
2. Driver
   Specify the driver name specified in the odbcinst.ini file when you registered the driver.
   
3. PDHOST
   For a HiRDB/Single Server, specify the host name of the server machine on which the single server is located. For a HiRDB/Parallel Server, specify the host name of the server machine on which the system manager is located.
   If this item is omitted, the value specified for PDHOST in the client environment definition is assumed. For details about PDHOST, see 6.6.4 Environment definition information.
   
4. PDNAMEPORT
   Specify the port number (value specified in the pd_name_port operand in the system definition) of the HiRDB server to be accessed.
   If this item is omitted, the value specified for PDNAMEPORT in the client environment definition is assumed. For details about PDNAMEPORT, see 6.6.4 Environment definition information.
   
5. INIFLNAME
   Specify the absolute path name of the HiRDB client environment definition file. You use this item to change specification values for HiRDB client environment variables for a particular data source. For example, if you are using the high-speed connection facility (PDSERVICEPORT) to connect to multiple HiRDB systems, you can use this item to specify the file name of the HiRDB client environment definition file and change the connection destination for each data source.
   If this item is omitted, the values specified in the environment definition are assumed.
   In the UNIX edition, the HiRDB client environment definition file (HiRDB.ini) is not created. Therefore, you must provide the file and then specify it in this item.