Select or (32-bit) based on your needs. Choose the DSN Type: User DSN: Only available to the current user.
| Problem | Likely Fix | | :--- | :--- | | “Driver not found” but you just installed it | You opened the wrong ODBC admin tool (32 vs 64). Check step 3 again. | | Installer fails with “missing VC++ runtime” | Download and install Microsoft Visual C++ Redistributable . | | Driver doesn’t appear after install | Run the installer as . Some drivers require registry write access. | | Connection test fails with “cannot connect” | Check firewall, server address, and that the database allows remote connections. | how to install odbc driver in windows
Before closing the window, always click the or Test Connection button. Select or (32-bit) based on your needs
Installing the driver is only half the battle. You now need to create a so your apps can find the database. Open ODBC Data Source Administrator: Press the Windows Key and type ODBC . Check step 3 again
The Data Connectivity Team Reading time: 4 minutes
ODBC (Open Database Connectivity) drivers are the unsung heroes of modern data architecture. They allow your Windows applications—whether it’s Microsoft Excel, Power BI, Tableau, or a custom Python script—to talk to databases like PostgreSQL, MySQL, SQL Server, or even cloud services like Snowflake.