Windows 7 X64 Odbc |verified|

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

: Found via Control Panel > Administrative Tools > Data Sources (ODBC). windows 7 x64 odbc

ODBC (Open Database Connectivity) is a standard interface for accessing databases. This guide will walk you through the process of setting up ODBC on a Windows 7 x64 system. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC

| Version | Location | Purpose | |---------|----------|---------| | | C:\Windows\System32\odbcad32.exe | Manages 64-bit DSNs for 64-bit apps | | 32-bit | C:\Windows\SysWOW64\odbcad32.exe | Manages 32-bit DSNs for 32-bit apps | If you want to create a connection string

: The Start Menu shortcut opens the 64-bit version by default. If your application is 32-bit (like many older MS Office versions), you need the 32-bit administrator!

System DSNs are great, but they are tied to the machine and the registry architecture. If you want to create a connection string that works regardless of architecture (and can be emailed to a colleague), consider using . These store the connection info in a simple text file ( .dsn ). However, remember that the machine reading the File DSN still requires the appropriate driver architecture to be installed.