Download New! And Install Odbc Driver – Editor's Choice

This is the most common pitfall. If your application is 32-bit (like older versions of Excel), you must install a 32-bit driver. If your app is 64-bit , you need a 64-bit driver. On modern Windows systems, you can often install both side-by-side to be safe. 3. Where to Download ODBC Drivers

Ensure your DSN (Data Source Name) is created in the correct version of the ODBC Administrator tool. download and install odbc driver

Double-click the downloaded file and follow the setup wizard. You will usually just need to accept the terms and click "Next." Open ODBC Data Source Administrator: Press the Windows key and type "ODBC Data Sources." This is the most common pitfall