You will see "ODBC Data Sources (32-bit)" and "ODBC Data Sources (64-bit)." Select the one that matches your software's architecture. Step 1: Downloading the Necessary Drivers
Once the driver is installed, you use the Administrator to create a . This is essentially a shortcut that stores your connection settings. Open the Administrator (32 or 64-bit). download odbc data source administrator
This is the most common error. It means you are trying to use a 32-bit DSN in a 64-bit program (or vice versa). Re-open the version of the Administrator that matches your app and recreate the DSN there. 2. Driver Not Showing Up You will see "ODBC Data Sources (32-bit)" and
Select the you just downloaded from the list and click Finish . A configuration window will pop up. Enter: Name: Give it a simple name (e.g., Sales_Data ). Server: The IP address or URL of your database. Authentication: Your username and password. Open the Administrator (32 or 64-bit)