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.

I get the same error with Pervasive and SapDB. I don't get the error
with MS Access, MS SQL Server and MySQL.

I think that somehow .net is unable to find out which column is the key.

I can send the SQL Trace. I can send the source for the program
if that helps?

Anybody have similar problems?

Thanks for your time.


Christoph