Add Odbc Driver Windows ~upd~ Jun 2026
Windows comes with a few built-in drivers (like SQL Server), but most modern databases require a specific download from the vendor.
You create a driver from scratch — you must install one from a database vendor or third party.
If your app is 32-bit (like older Excel versions), use the 32-bit driver. If your app is 64-bit, use the 64-bit driver. add odbc driver windows
Navigate to the tab to ensure your new driver appears in the list. Step 3: Create a New DSN
Adding an ODBC driver on Windows involves installing the driver, configuring the driver, and testing the ODBC connection. By following these steps, you can successfully add an ODBC driver on Windows and connect to your database. If you encounter issues, refer to the troubleshooting section to resolve common problems. Windows comes with a few built-in drivers (like
Your username and password (or Windows Authentication).
Once the executable ( setup.exe or .msi ) is downloaded, follow these steps: If your app is 64-bit, use the 64-bit driver
Follow the wizard prompts to place the driver files on your system. Step 2: Open the ODBC Data Source Administrator
Ensure the database port (e.g., 1433 for SQL Server, 3306 for MySQL) is open on your network.
If you are unsure which architecture you need, or if you run a mix of applications, download and install both the 32-bit and 64-bit versions of the driver.
Open Database Connectivity (ODBC) is a standard interface for accessing databases. ODBC drivers enable applications to connect to various databases, such as Microsoft SQL Server, Oracle, and MySQL. In this write-up, we will focus on adding an ODBC driver on Windows. We will cover the steps to install and configure an ODBC driver, as well as troubleshoot common issues.
































