F. Features Introduced in Ingres 9.1 (Ingres 2006 Release 2) : Connectivity Enhancements : ODBC Enhancements
 
Share this page                  
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()
SQLGetInfo()
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.