How To Configure Odbc Connection In Windows 7

Configure a Data Source (Windows)

A data source configuration is a drove of information that identifies the database you want to access using the ODBC driver. Yous can configure equally many information sources as you lot require. Once defined, a information source is available for utilize by any application that uses ODBC.

ODBC data sources are a user-friendly way of connecting to a database. You can, however, connect to a database without them by using only a connection cord. For details, see Connection String Keywords (see folio Connectedness String Keywords).

Note:On 64-bit Windows, when creating a new data source using the ODBC Information Source Ambassador, the ODBC Commuter does not announced in the list of drivers on the User DSN or System DSN tab. The ODBC Driver is a 32-bit driver and appears simply in the 32-bit ODBC Data Source Administrator. The ODBC Information Source Administrator shortcut in the Control Panel is a 64-fleck shortcut and volition bring up 64-fleck ODBC Information Source Administrator and merely display the 64-fleck drivers.

Note:To bring up the 32-bit ODBC Data Source Ambassador, which will list the ODBC Driver, run c:\windows\SysWow64\odbcad32.exe.

To configure a new information source on Windows

1. Run the ODBC Data Source Ambassador provided on Windows.

To practice this on Windows 7, click Start, Control Console, System and Security, Administrative Tools, Data Sources (ODBC).

The ODBC Data Source Ambassador is displayed:

You can ascertain one or more data sources for each installed commuter. The data source name must provide a unique clarification of the data; for case, Payroll or Accounts Payable.

A data source tin be divers as system or user, depending on whether it must be visible to all users (and services) or only the electric current user.

ii. Select the User DSN or the System DSN tab, depending on your requirements, and click Add.

Note:A arrangement 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 divers previously for the ODBC 2.8 driver to the new ODBC 3.v driver, remove the DSN by selecting it in the ODBC Data Source Administrator Information Sources list, and clicking Remove. Add the DSN again using the new ODBC commuter.

3. Select the Ingres driver and click Cease.

The Ingres ODBC Administrator dialog opens.

4. Fill in the necessary fields in the Ingres ODBC Ambassador. For field descriptions, click the Assistance button.

Source: https://docs.actian.com/ingres/10s/Connectivity/Configure_a_Data_Source_%28Windows%29.htm

Posted by: rosadoanxich.blogspot.com