10. Understanding ODBC Connectivity : Configure a Data Source (Windows)
Share this page                  
Configure a Data Source (Windows)
A data source configuration is a collection of information that identifies the database you want to access using the ODBC driver. You can configure as many data sources as you require. Once defined, a data source is available for use by any application that uses ODBC.
ODBC data sources are a convenient way of connecting to a database. You can, however, connect to a database without them by using only a connection string. For details, see Connection String Keywords (see page Connection String Keywords).
Note:  On 64-bit Windows, when creating a new data source using the ODBC Data Source Administrator, the ODBC Driver does not appear in the list of drivers on the User DSN or System DSN tab. The ODBC Driver is a 32-bit driver and appears only in the 32-bit ODBC Data Source Administrator. The ODBC Data Source Administrator shortcut in the Control Panel is a 64-bit shortcut and will bring up 64-bit ODBC Data Source Administrator and only display the 64-bit drivers.
Note:  To bring up the 32-bit ODBC Data Source Administrator, which will list the ODBC Driver, run c:\windows\SysWow64\odbcad32.exe.
To configure a new data source on Windows
1. Run the ODBC Data Source Administrator provided on Windows.
To do this on Windows 7, click Start, Control Panel, System and Security, Administrative Tools, Data Sources (ODBC).
The ODBC Data Source Administrator is displayed:
You can define one or more data sources for each installed driver. The data source name must provide a unique description of the data; for example, Payroll or Accounts Payable.
A data source can be defined as system or user, depending on whether it must be visible to all users (and services) or only the current user.
2. Select the User DSN or the System DSN tab, depending on your requirements, and click Add.
Note:  A system DSN pointing to a public server definition is required for Microsoft Internet Information Server (IIS) and Microsoft Transaction Server (MTS).
The Create New Data Source dialog opens, which lists all the ODBC drivers installed on your system.
Note:  To switch ODBC DSNs defined previously for the ODBC 2.8 driver to the new ODBC 3.5 driver, remove the DSN by selecting it in the ODBC Data Source Administrator Data Sources list, and clicking Remove. Add the DSN again using the new ODBC driver.
3. Select the Ingres driver and click Finish.
The Ingres ODBC Administrator dialog opens.
4. Fill in the necessary fields in the Ingres ODBC Administrator. For field descriptions, click the Help button.