Subject Re: [ib-support] Problem with the XTG odbc driver and microsoft
Author Martijn Tonies

> I am having trouble in Microsoft Visual Studio.NET with a VB.NET
> program connecting to FireBase with the XTG ODBC driver.
> I can connect and read ok with the latest beta version but if I try and
> update a recordset I get the following error:
> Dynamic SQL generation for the UpdateCommand is not supported against a
> SelectCommand that does not return any key column information.

Seems like you don't have a primary key or unique constraint at the table...


(if not, ask the creators of the driver)

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase

Firebird Workbench - the developer tool for Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."