When connecting to an Access DB (.mdf) the application shows following message:
'---------------------------
ODBC Driver info
'---------------------------
Cannot guarantee to find object '' for one of the following reasons:
- The usage of SQL_ATTR_METADATA_ID is not supported on the statement level
- The usage of SQL_ATTR_METADATA_ID is not supported on the connection level
- SQLInfo of catalog identifiers is not simply SQL_IC_UPPER or SQL_IC_LOWER
and the catalog is not treated in a case-insensitive way.
And there is 'No information' for each table when trying to view columns, primary keys, foreign keys, etc.
When viewing Database /Meta-objects in database/ Schemas at the ODBC tab, the Access Engine driver reports that 'the additional function isn't implemented'.
Querying data seems to work fine - the results are output correctly. However any attempt to modify any field (through the table with query results) fails with the error: 'Cannot update, field "" of primary key "" is missing from your query!'
Last edit: Anton-V-K 2019-01-02
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
When connecting to an Access DB (.mdf) the application shows following message:
And there is 'No information' for each table when trying to view columns, primary keys, foreign keys, etc.
When viewing Database /Meta-objects in database/ Schemas at the ODBC tab, the Access Engine driver reports that 'the additional function isn't implemented'.
Querying data seems to work fine - the results are output correctly. However any attempt to modify any field (through the table with query results) fails with the error: 'Cannot update, field "" of primary key "" is missing from your query!'
Last edit: Anton-V-K 2019-01-02