Technical Notes

HiT ODBC Drivers and Reflection for IBM
Technical Note 1253
Last Reviewed 13-Nov-2008
Applies To
Reflection Standard Suite 2008
Reflection for IBM 2008
Reflection for IBM 2007
Reflection for IBM version 11.0 through 14.x
Reflection for the Multi-Host Enterprise Professional Edition version 11.0 through 14.x
Reflection for the Multi-Host Enterprise Standard Edition version 11.0 through 14.x
Reflection Suite for X version 11.0 through 14.x
Summary

HiT Software ODBC (Open Database Connectivity) LITE drivers enable you to query a database on an IBM AS/400 or IBM mainframe computer. This technical note describes how to access HiT ODBC LITE drivers that are available to certain Reflection customers (depending on your product, version, and maintenance status).

ODBC Drivers Provided with Reflection

Reflection for IBM provides read-only ODBC drivers from HiT Software:

• The HiT ODBC/400 LITE driver is designed to extract data from an AS/400 database.
• The HiT ODBC/DB2 LITE driver is designed to extract data from a mainframe database.

Due to contractual restrictions, the driver versions and availability depend on which Reflection for IBM (or suite) product version you are using. Note: Drivers are no longer included with version 14.0.5 (see below).

Product Version	HiT ODBC Drivers
2008 (15.2.x) 2007 (15.0.x)	HiT drivers are not included with the product. HiT ODBC/400 LITE version 8.0.0.0 and HiT ODBC/DB2 LITE version 6.0.0.0 are available on request for download by maintained customers upgrading from predecessor products that included HiT drivers. For more information, contact Technical Support at http://support.attachmate.com/contact/. Availability through Attachmate will continue through December 2009. To purchase the latest drivers, or to purchase drivers after 2009, please contact HiT Software at http://www.hitsw.com/.
14.0.5	HiT drivers are not included or available. To purchase the latest drivers, please contact HiT Software at http://www.hitsw.com/. If you obtained product version 14.0.5 as an upgrade, and you wish to continue using HiT drivers you previously received, please see the HiT Driver Continuity Agreement below for permission to do so.
14.0 (through 14.0.4)	Includes HiT ODBC/400 LITE version 7.0.0.5 and HiT ODBC/DB2 LITE version 5.1.0.1. These drivers can be found in the following locations: Downloaded Purchased Product: After running the downloaded executable, the Tools folder is created in the temporary installation folder (such as C:\~atq140ri). Product CD Media: On the product CD, open the Tools folder. Or, select the desired HiT driver from the installer list. Evaluation Product: Effective July 2007, time-limited trial evaluation drivers are no longer available.
13.x	HiT ODBC/400 LITE version 7.0.0.2 and HiT ODBC/DB2 LITE version 5.0.0.2 are available for downloading on request. For more information, contact Technical Support at http://support.attachmate.com/contact/.
12.x	Includes HiT ODBC/400 LITE version 6.1.2.9 and HiT ODBC/DB2 LITE version 4.1.1.1
11.x	Includes HiT ODBC/400 LITE version 6.1.0.7 and HiT ODBC/DB2 LITE version 4.1.0.0

Reflection for IBM versions 6.01 through 10.0 included earlier versions of HiT ODBC drivers.

Configuring the Driver

For information on installing and configuring the HiT ODBC/400 LITE driver, see Technical Note 1726. For information on configuring the HiT ODBC/DB2 LITE driver, see the online help included with your HiT driver.

Additional Information

For full-featured (read/write) ODBC drivers, or additional information on HiT products, contact HiT Software at http://www.hitsw.com/.

HiT Driver Continuity Agreement

Due to contractual restrictions, effective 12-Sep-2008, HiT drivers are not available to new customers of version 14.x. However, if you obtained a version 14.x release as an upgrade to a prior version, the paragraph below includes permissions to continue using the HiT drivers you previously received, and also to increase your HiT driver licensed deployment count through 31-Dec-2009.

THIS PARAGRAPH IS A LEGAL AGREEMENT (“Agreement”) BETWEEN ATTACHMATE CORPORATION (“Licensor”) AND YOU (REPRESENTING A PERSON OR ENTITY). BY EXERCISING ANY OF THE PERMISSIONS GRANTED HEREIN, YOU AGREE TO BE BOUND BY THE TERMS OF THIS AGREEMENT. PLEASE RETAIN THIS DOCUMENT WITH YOUR LICENSING RECORDS. If you have received any Reflection for IBM version 14 product at point-version 14.0.5 or higher as an upgrade (the “Upgrade Version”) from a Reflection for IBM product at version 14 or lower that includes a HiT driver component, then (i) notwithstanding any terms to the contrary in the software license agreement (“SLA”) accompanying the Upgrade Version, you may continue to use the HiT driver software with the Upgrade Version, and subject to the SLA, as if the HiT driver software had been delivered with the Upgrade Version and (ii) if you acquire additional licensed unit count for the Upgrade Version at any time before 1 January 2010 (the “Freeze Date”), you may correspondingly increase your deployed HiT driver count. The permissions granted in this Agreement will apply to each subsequent Reflection 14 point release you receive as an upgrade prior to the Freeze Date. As of the Freeze Date, you may continue using your then-licensed HiT driver software, at your then-licensed unit count, and subject to the applicable SLA. You may NOT use the Reflection version 14 (or earlier) HiT driver software with successor Reflection products such as Reflection for IBM 2007 or Reflection for IBM 2008. IF YOU DO NOT AGREE to the terms of this Agreement, then you may not exercise any of its permissions, and you must comply with SLA terms requiring removal of the HiT driver software when you deploy the Upgrade Version.

Related Technical Notes

1726	Installing and Configuring ODBC/400 LITE Drivers
9991	Reflection for IBM Technical Notes