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.