On , two ODBC Administrator tools exist:
Once you have opened the correct version of the Administrator tool, follow these steps to set up your Data Source Name (DSN): ODBC for 32 bit applications on Windows 7 x64
Create a System DSN silently:
Used for 64-bit applications. You can access this via Control Panel > Administrative Tools > Data Sources (ODBC) . Its physical path is C:\Windows\System32\odbcad32.exe .
| Database | Recommended driver | |----------|--------------------| | SQL Server 2008–2016 | SQL Server Native Client 11.0 | | SQL Server 2017+ | ODBC Driver 17 for SQL Server | | MySQL | MySQL ODBC 8.0 Unicode Driver | | PostgreSQL | PostgreSQL Unicode (x64) | | Oracle | Oracle in OraClient12Home1 | | Access/Excel | Microsoft Access Driver (*.mdb, *.accdb) – included with Microsoft Access Database Engine 2010 Redistributable |