OLEDB CommandBuilder problem
When trying to use the OleDbCommandBuilder with DB2 we get the
following error:
An unhandled exception of type 'System.InvalidOperationException'
occurred in system.data.dll
Additional information: Dynamic SQL generation is not supported
against a SelectCommand that does not return any base table
information.
I understand that this is a limitation of IBM's OLEDBProvider. It
appears that it does not return any primary key information as the
tables PrimaryKey.Length = 0. But IBM's own documentation says that
the IColumnsInfo and IColumnsRowset interfaces are supported.
http://www.***.com/
Is there any way to work around it, so we can use the
OleDBCommandBuilder? Even if we have to create our own custom
implementation of the command builder.
