User DSN Tab

  • Article

Adds, deletes, or sets up data sources with user data source names (DSNs). These data sources are local to a computer and accessible only by the current user.

Control

Description

User Data Sources

Lists all user DSNs, including the name and associated driver of each DSN. You will see the Platform column if you are working on a 64-bit version of a Windows operating system, if you are using the native odbcad32.exe or in Wow64. Possible values for the Platform column:

  • "32-bit" means that the DSN can only be used in a 32-bit application and can only be configured in the 32-bit ODBC Administrator tool (WoW64 mode).

  • "64-bit" means that the DSN can only be used in a 64-bit application and can only be configured in the 64-bit ODBC Administrator tool (Native mode).

  • "32/64-bit" means that the DSN can be used in both a 32-bit application and 64-bit application and can be configured in both the 32-bit and 64-bit ODBC Administrator tool (WoW64 mode and Native mode).

  • "N/A" means that the DSN cannot be used in either a 32-bit application or 64-bit application, and cannot be configured in either the 32-bit or 64-bit ODBC Administrator tool (WoW64 mode and Native mode). You need to re-install the corresponding driver or remove the DSN.

Double-clicking a user DSN displays the driver-specific data source setup dialog box.

Add

Click to add a new user data source. In the Create New Data Source dialog box that appears, choose the driver for which you are adding a user data source and click Finish; a driver-specific setup dialog box will appear.

Remove

Click to remove a selected user data source name from the Users Data Sources list.

Configure

Click to change the configuration of a selected user data source. This will display the driver-specific data source setup dialog box.

If a DSN has a User Data Sources value "N/A", you cannot configure it, you can only remove it.

OK

Closes the ODBC Data Source Administrator dialog box. You do not have to click OK to accept changes to the User Data Sources list. Changes to the list are accepted once you click OK in the data source setup dialog box.

Cancel

Closes the ODBC Data Source Administrator dialog box but does not undo changes made via other dialog box controls.

Help

Displays this Help screen.