Open . (This defaults to the 64-bit version). For 32-bit Drivers
Upon downloading and installing the 64-bit driver package, the driver registers itself within the Windows Registry specifically under the 64-bit keys. Once installed, the administrator must use the correct Data Source Administrator tool to configure a Data Source Name (DSN). This DSN acts as the logical bridge between the application and the physical database. In Windows 7, failure to select the correct administrator tool usually results in the driver not appearing in the list, leading to troubleshooting delays. Proper configuration in Windows 7 also involved setting up System DSNs versus User DSNs, a distinction that dictated the scope of accessibility for the data connection across different user profiles on the machine.
Most modern drivers (like the Microsoft ODBC Driver for SQL Server) follow a standard installation path.
If you installed a driver but don't see it in the ODBC Administrator, you are likely looking at the wrong version. Check the SysWOW64 folder if you are looking for a 32-bit driver. Error: Architecture Mismatch
