Microsoft Access Database Metadata Tables Query from ADF

Balan Murugan 1 Reputation point
2021-02-05T10:32:30.317+00:00

We have a requirement for automatic metadata capture (List of tables and columns) from Microsoft Access Database Tables. For this, we need to query the MS Access Database metadata tables to get the details.

As part of our project requirements, we have implemented the same for Microsoft SQL Server tables.

When we tried to query the "information_schema.tables" and "informaton_schema.columns" from ADF lookup activity which points to MS Access Database (Northwind.mdb) Dataset, we get the following error.

Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\Program Files\Microsoft Integration Runtime\4.0\Shared\information_schema.mdb'.,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\Program Files\Microsoft Integration Runtime\4.0\Shared\information_schema.mdb'.,Source=ACEODBC.DLL,'

But, we could able to query the Microsoft Access Database metadata tables from the client tools like DBeaver. Attached the screen shot for DBeaver queries.

Could you please help us in extracting the MS Access metadata tables from ADF lookup activity ?64458-ms-acess-dbeaver-query.jpg

Active Directory Federation Services
Active Directory Federation Services
An Active Directory technology that provides single-sign-on functionality by securely sharing digital identity and entitlement rights across security and enterprise boundaries.
1,208 questions
0 comments No comments
{count} votes