Hi,
I have a problem with getting Constraints for Access tables with UniDac Version 7.0.2.
If I use a TUniMetaData object with MetaDataKind := 'Constraints' on a SQL Server then it returns all the Constraints for a given Table. If I do the same for an Access database (have tested mdb and accdb) then the resulting recordset is always empty.
Is there a trick to get the desired results or is this simply not implemented?
I'd really like to have unified code for both versions without having to implement the specific way of getting the info from an Access Database's "MSysRelationships" table.
Best regards.
Getting Constraints for Access (mdb/accdb) Tables
Re: Getting Constraints for Access (mdb/accdb) Tables
TAccessUniProvider for connection with Microsoft Access uses the standard Microsoft Access Driver. When retrieving Constraints meta information, the driver returns the '[Microsoft] [ODBC Driver Manager] Driver does not support this function' error to UniDAC. Therefore, UniDAC returns an empty recordset. And we cannot influence this driver behavior.