Connectivity Enhancements

The connectivity enhancements ease migration of applications from non-Ingres database architectures and improve interoperability.

ODBC Enhancements

The Ingres ODBC 3.5 driver is enhanced to support most of the ODBC 3.x specifications. The enhancements offer these benefits:

• Better integration with Microsoft products such as Access and Excel, and with other third-party products that use ODBC
• Easier migration from other databases, such as Oracle and SQL Server
• Improved performance

The new Ingres ODBC driver includes several new features, including the following ODBC 3.x functions:

• SQLBrowseConnect()
• SQKGetInfo()
• SQLGetTypeInfo()
• SQLDescribeParam()
• SQLColumnPrivileges()

  Note: Not supported on gateways except RMS.

• SQLTablePrivileges()

  Note: Not supported on gateways except IMS, VSAM, and RMS.

The following functions are supported through the ODBC escape sequence syntax:

• CONVERT
• INTERVAL scalar

The following features in Ingres 2006 Release 2 are supported:

• The DESCRIBE INPUT query
• New data types for ISO dates and time intervals

For more information, see the Connectivity Guide.

JDBC Enhancements

The following JDBC enhancements ease application migration and performance:

• The Ingres JDBC driver supports the Java 2 Platform Standard Edition 5.0 (J2SE 5.0) specification, excluding RowSets.
• The JDBC cursor default is changed to CURSOR=READONLY. This cursor mode setting typically generates improved JDBC performance, especially for selects returning many rows. A configuration parameter lets you retain the old default, if preferred.
• The JDBC ParameterMetaData interface, which is related to the DESCRIBE INPUT functionality in the DBMS, is supported. 
• Enhanced support is provided for XA transactions in J2EE environments using the IngresXADataSource.

For more information on JDBC, see the Connectivity Guide.

Ingres .NET Data Provider 2.0

The Ingres .NET Data Provider is enhanced to support the Microsoft .NET 2.0 Framework and MS Visual Studio 2005.

The Ingres .NET Data Provider 2.0 takes advantage of the .NET 2.0 features for greater usability, interoperability, and flexibility of Ingres data access in a Microsoft .NET environment. It supports the new base classes introduced into the data provider class hierarchy by Microsoft. For Visual Studio 2005, the data provider supports the new Server Explorer window, making it easier to manage data source definitions.

For more information, see the Connectivity Guide.

Note: The new Ingres.Client assembly of Ingres2006 Release 2 replaces the old Ca.Ingres.Client assembly of Ingres2006. Old applications that want to use the new Ingres.Client assembly require source application changes.

PHP 5 Support

The Ingres PHP driver is updated to support the features of PHP 5.

For more information, see the download page of the Ingres web site.

Support for IPv6 Networks

Ingres supports Internet Protocol version 6 (IPv6) networks. IPv6 provides more addresses for networked devices and more efficient processing than does IPv4.

Use of IPv6 by Ingres is transparent. Ingres immediately begins using IPv6, wherever possible, as the network is migrated to IPv6.

Ingres 2006 Release 2 supports both IPv6 and IPv4 addresses. IPv4 must be used to access versions of Ingres prior to Ingres 2006 Release 2.

For details, see the Connectivity Guide and IPv6 Configuration.