By Achilles Hill | Last Updated
The ODBC Data Source Administrator allows you to configure DSNs for databases like Oracle, SQL Server, or Excel. How can you easily open ODBC Data Source Administrator on Windows 10 computer? Read on to find 5 commonly-used methods.
Show the Run dialog using Windows+R, type odbcad32 and tap OK.
Step 1: Get into Command Prompt.
Step 2: Input odbcad32 and press Enter.
Type odbc in the search box on taskbar, and choose Set up ODBC data sources from the list.
Step 1: Open Windows PowerShell by search.
Step 2: Input odbcad32.exe and hit Enter.
Step 1: Access Control Panel.
Step 2: Type odbc in the top-right box, and choose Set up ODBC data sources (32-bit) or Set up ODBC data sources (64-bit) according to your need.
64-bit ODBC (System32) is for 64-bit apps.
32-bit ODBC (SysWOW64) is for older 32-bit apps.
Using the wrong version causes errors like “Data source name not found”—because user or system DSNs are stored separately for each.
Q1: Which ODBC version should I use?
You can use the 64-bit tool for modern applications (e.g., SQL Server, Access 64-bit), and use 32-bit (SysWOW64) when working with 32-bit apps like older Office versions.
Q2: Where to find ODBC application?
On 64-bit Windows, you can find it located in C:\Windows\System32\odbcad32.exe. As for 32-bit variant, it stores in C:\Windows\SysWOW64\odbcad32.exe.
Q3: How do I know which drivers are installed?
You can run ODBC Data Source Administrator with the above methods. Then click the Drivers tab to check driver names and versions.
Related Articles:
How to Reset Windows 10 Forgotten Password 
How to Bypass Windows 10 Password Login with/without Password 
Easy Guide to Reset Windows 10 Admin Password Like an Expert 
4 Tips to Change Windows 10 Password without Knowing Current Password 
Can't Sign into Microsoft Account Windows 10 | Account Locked/Blocked 
