Subject Re: [ib-support] Problem with the XTG odbc driver and microsoft vs.net
Author Martijn Tonies
Hi,

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

Right?

(if not, ask the creators of the driver)


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

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