Why Isn’t My ODBC Connection Working — and How Can I Fix It?

If your ODBC connection to RollMaster isn’t working, follow this troubleshooting tip to resolve a common issue that can prevent the connection from succeeding.

🧪 ODBC Connection Issue — Troubleshooting Option

Some applications — especially Power BI (UWP) — cannot load external libraries properly. When that happens, the ODBC driver can fail because it can’t find required DLLs.

To fix this:

1. Locate the AcuXDBC DLL files

   • Typically found in the AcuXDBC installation folder under "bin". 

2. Copy the necessary DLLs to your Windows System folder

   • If you’re using the 64‑bit AcuXDBC driver, run this command from the AcuXDBC "bin" directory.

   • This ensures Windows can load the DLLs even if the application (like Power BI) runs in an environment that doesn’t automatically access the driver’s native path.

🧠 Why This Helps

💡 Universal Windows Platform (UWP) applications such as Power BI may isolate themselves from external libraries for security and stability reasons. Moving the AcuXDBC DLLs to the system directory gives Windows a place where these apps can access them. (broadlumeerp.zendesk.com)

❗ Notes & Recommendations

✔ Check whether your application is running as UWP — this is most common with Microsoft Store versions of Power BI.
✔ Make sure you copy the DLLs to the correct System folder for your driver architecture (64‑bit vs 32‑bit).
✔ If you still see connection errors after this step, revisit your DSN configuration and verify that the driver, server, and credentials are all correct.

📌 Summary