Icon View Incident Report

Serious Serious
Reported By: Jeremy Martin
Reported On: 5/13/2005
For: Version 4.20 Build 2
# 2049 ODBC Driver Catalog Functions Not Working Properly with Remote Connections to a Database Server

The following code causes this error:

Error Message

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

myAdapter := OdbcDataAdapter.Create('select * from table where id =

myBuilder := OdbcCommandBuilder.Create(myAdapter);

Comments Comments
There was a general problem with the way the catalog functions were internally creating the metadata tables. Another symptom of this same problem was this error on the database server:

13/05/2005 10:34:59 AM [ERROR] Engine error [DBISAM Engine Error # 11308 An invalid or unknown request was made to the database server at ''] [Client Version: 4.20 User Name: admin Address: Encrypted: No Request: REQUEST_CREATECURSOR Thread: 1436 Session: 38932488]

whenever any catalog functions were called in the ODBC driver.

Resolution Resolution
Fixed Problem on 5/17/2005 in version 4.20 build 3

Products Affected Products Affected
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard with Source