To create a new ODBC data source, use the Windows ODBC Data Source Administrator dialog. You can bring up this dialog in one of three ways:

  • Click the ODBC Admin button in the Setup or Manage Databases dialogs.

  • If you use a 64-bit computer, you have to use the 32-bit ODBC Administrator rather than the default 64-bit one. To do that, open Window Explorer, navigate to C:\Windows\SysWoW64, find ODBCAD32.exe, and double-click it.

  • If you use a 32-bit computer, click the Start button in your Windows Taskbar and choose Control Panel. Double-click "Administrative Tools" within the Control Panel and then double-click "Data Sources (ODBC)."

The ODBC Data Source Administrator dialog appears similar to the following.

To create a new data source, do the following steps:

Step 1. In either the User DSN or System DSN pages, click the Add button. The Create New Data Source dialog appears, looking something like the following. Select the appropriate driver, and click the Finish button.

What happens next depends on the driver you selected. The rest of these steps assume you are using the SQL Server driver. Please see your system administrator for assistance with other drivers.

Step 2. The setup dialog appears. Type something descriptive for the Name (such as "My Database") and Description, then choose the server from the drop-down list.

Step 3. Click the Next button to go to the next page of the dialog. Check with your system administrator to see what settings to use in this page; you can leave the choices set at their default values if you aren't sure what settings to use.

Step 4. Click the Next button to go to the next page of the dialog. In the Change the default database to setting, select the database you want to query on from the list (you may have to ask your system administrator for the name of the database). You can leave the rest of the settings at their default values.

Step 5. Click the Next button to go to the next page of the dialog. Check with your system administrator to see what settings to use in this page; you can leave the choices set at their default values if you aren't sure what settings to use.

Step 6. Click the Finish button to finish the setup. You then see a dialog that looks something like the following. Click the Test Data Source button to ensure everything works, then click the OK button.


© ACEware Systems, Inc., 2018 • Updated: 06/07/16
Comment or report problem with topic