.NET Framework Data Provider for ODBC is one of the .NET Framework class libraries provided by Microsoft. .NET Framework Data Provider for ODBC enables you to automatically generate SQL statements for updating a data source by using the OdbcCommandBuilder class.
The following limitations apply when the HiRDB ODBC 3.5 driver is used with .NET Framework Data Provider for ODBC to automatically generate SQL statements:
- Automatic generation of SQL statements via .NET Framework Data Provider for ODBC is supported by HiRDB version 08-04 or later. If a HiRDB version earlier than 08-04 is used, operation is not guaranteed.
- If you specify a correlation name as a table name in the SELECT statement that is specified in the SelectCommand property of the OdbcDataAdapter class, which is the base of automatic generation of SQL statements, the HiRDB server returns the base table name to the HiRDB ODBC 3.5 driver. Therefore, a valid SQL statement is generated for the HiRDB server. However, if an alias is specified as a table name, the HiRDB server does not return a table name to the HiRDB ODBC 3.5 driver. As a result, no table name can be returned to .NET Framework Data Provider for ODBC that requires the value of SQL_DESC_BASE_TABLE_NAM for the SQLColAttribute function of the HiRDB ODBC 3.5 driver. In such a case, automatic generation of SQL statements is not guaranteed.
- If you specify an alias as a column name in a SELECT statement that is specified in the SelectCommand property of the OdbcDataAdapter class, which is the base of automatic generation of SQL statements, the HiRDB server returns the alias of the column to the HiRDB ODBC 3.5 driver. Therefore, the alias of the column is used in the automatically generated SQL statement. If an SQL statement containing an alias of a column is executed, the HiRDB server returns an error because no such column actually exists.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.