Odbc Driver 64 Bit Windows 7 Access

Introduction

If you are running a 64-bit version of Windows 7, it is critical to understand that 32-bit and 64-bit ODBC drivers are . A 64-bit application (e.g., a 64-bit version of Microsoft Excel, Access, or a custom .NET application) cannot use a 32-bit ODBC driver, and vice versa.

If you ever see an architecture mismatch error, you are likely using the wrong ODBC Administrator. Always launch C:\Windows\System32\odbcad32.exe for 64-bit configuration.

This article explains how to manage 64-bit ODBC drivers on Windows 7, where to find them, and how to troubleshoot common issues. One of the most confusing aspects of Windows 7 (and subsequent versions) is that the operating system includes two separate ODBC Data Source Administrator tools .