A common pitfall is a "Bitness Mismatch". Your driver's architecture must match the connecting to the database, not necessarily your Windows OS:
This is the most up-to-date version and the recommended replacement for older standalone drivers. You can download it directly from the Official Microsoft Support Page .
Microsoft generally prevents installing a 64-bit driver if a 32-bit version of Office is already present (and vice versa). To bypass this for development, you can run the installer via the command line with the /passive flag. 3. How to Install and Configure
