|
|
|
The following sections list the ODBC driver software, platform, and protocol requirements. For additional information relating to the ODBC driver, see the Ingres Corporation web site. The latest release of the ODBC Driver is also available for free download on the Ingres Corporation web site.
|
|
|
The following are the installation requirements for the ODBC driver.
Windows: Microsoft's ODBC Driver Manager must be installed to use the ODBC driver (release 2.5 or above of the ODBC Driver Manager is acceptable). The ODBC 3.0 SDK can be downloaded from the Microsoft Universal Data Access web site at http://www.microsoft.com/data.
UNIX and VMS: The Ingres ODBC CLI is the preferred ODBC driver manager if no other ODBC drivers are required. No additional download is required. The only requirement for installation is to execute the utility iisuodbc. The iisuodbc utility provides configuration information to Ingres and creates an ODBC configuration file.
If the ODBC application requires non-Ingres ODBC drivers, unixODBC Driver Manager can be installed to use the Ingres ODBC driver. The unixODBC Driver Manager is available as freeware and can be downloaded from http://unixODBC.org. The download includes a Readme file with instructions for UNIX, Linux and VMS. On Unix and Linux, the Ingres ODBC driver can also be used with the CAI/PT Driver Manager, which is available from Computer Associates.
Note: The Ingres ODBC driver does not support the Merant ODBC Driver Manager.
|
|
|
The Ingres ODBC driver supports the following protocols:
|
|
|
Each release of Ingres requires a compatible ODBC driver. On Windows, if your machine contains an Ingres 2.8 driver, the driver was registered with a driver name of "Ingres" and possibly "Ingres 2.8" if ODBC patches were installed. The Ingres installer registers the Ingres 2006 ODBC driver as "Ingres 3.0." Previous installations of Ingres r3, which were also registered as "Ingres 3.0," are overwritten by the Ingres installer.
The ODBC 2.8 driver is ODBC 2.0 API compliant, while the ODBC 3.5 driver is ODBC 3.0 API compliant.
UNIX, Linux, and VMS use an odbcinst.ini configuration file instead of a registry. A succession of ODBC driver names are maintained that correspond to the Ingres release. No ODBC 2.8 drivers are supported on UNIX, Linux, or VMS.
|
|
|
On Linux, if you want to run the Ingres 2006 Release 2 ODBC driver with earlier versions of Ingres on the same machine, existing DSN definitions that point at "Ingres" will now reference the Ingres 2006 Release 2 version of the Ingres ODBC.
On Windows, existing DSN definitions will still point at the prior driver settings because the driver path is hard-coded in the registry and takes precedence over the driver name. We recommend that you delete your existing ODBC DSN definitions and create new ones after installing the Ingres ODBC driver.