OLEDB CommandBuilder problem 
Author Message
 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.



Sat, 07 Aug 2004 22:55:13 GMT
 OLEDB CommandBuilder problem

The only way round is not to use it. Use the MS OLEDB over ODBC driver.


Quote:
> 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-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/d...
.d2w/report?fn=db2v7agdb2age70.htm#HDROLEDBDTM_TABLE

- Show quoted text -

Quote:

> 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.



Tue, 10 Aug 2004 16:08:22 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SWsoft OLEDB vs PVSW OLEDB/ PVSW problems

2. jet3.51 OLEDB vs jet4.0 OLEDB

3. ADO vs OLEDB COM vs OLEDB ATL templates

4. OLEDB Parameterised Query (beginner OLEDB)

5. Microsoft OLEDB provider or Oracle OLEDB provider

6. Oracle OLEDB vs MS OLEDB for Oracle performance?

7. Microsoft ADO Data Control 6.0(SP4) (OLEDB) and Microsoft DataGrid 6.0 (SP5) (OLEDB)

8. ASP - OLEDB Provider done yet login problem exsists

9. oledb for oracle problem?

10. OLEDB problems with Linked servers

11. Update problems with ADO/OLEDB for SQL6.5

12. OLEDB connection problem


 
Powered by phpBB® Forum Software