MS Access ODBC

Unknown

MS Access ODBC

Unknown

I am not sure how to get this working. I have tried in parts before to connect Decisions with an ODBC driver (MongoDB, Postgres) - but have been unsuccessful.

Now, I am trying to integrate with an Access DB this time but I am not sure what is causing the error.

• created a database integration, and selected the ODBC type flow (Access was already there in-built) and used the connection strings (tried a few different options from: [url=https://www.connectionstrings.com/microsoft-access-odbc-driver/]https://www.connectionstrings.com/microsoft-access-odbc-driver/[/url]). See screenshot to see my inputs. Kept on getting the following error:
  [img]https://tirade.decisions.com/decisions/Primary/largefilehandler.ashx?fileReferenceId=80661b38-a47e-4df7-b26e-718fb87a710c[/img]
  Any suggestions on how to fix this?

Unknown

Try downloading ODBC Data Sources 64 bit drivers. The problem is caused by Microsofts ODBC Data Sources 64 bit does not come with Microsoft Access ODBC 64 Bit drivers. Since Decisions is a 64 bit program it will look for the ODBC driver in ODBC Data Sources 64bit. If it can’t find the driver this error will occur. To resolve this issue download the “Microsoft Access Database Engine 2016 Redistributable.” The AccessDatabaseEngine_X64.exe contains the 64 bit drivers the url to that download can be found here:
https://www.microsoft.com/en-us/download/confirmation.aspx?id=54920 Once this is installed the 64 bit drivers will be available. Use the standard access connection string format when filling out the “Connection String” field in Decisions. The standard Access connection string format is found here https://www.connectionstrings.com/microsoft-access-accdb-odbc-driver/