Contents Index Introduction Connecting to a Data Source Using a Logon Dialog Box

iAnywhere Solutions ODBC Drivers
  iAnywhere Solutions ODBC Driver for Oracle

Configuring data sources


On Windows, data sources are configured and modified through the ODBC Administrator.

In the UNIX environment, there is no ODBC Administrator. To configure a data source in the UNIX environment, you must edit the system information file using the attributes in Values for IANAAppCodePage Connection String Attribute. You must also edit this file to perform a translation.

For more information, see The system information file (.odbc.ini).

To configure an Oracle data source

  1. Start the ODBC Administrator to display a list of data sources.

  2. If you are configuring an existing data source, select the data source name and click Configure to display iAnywhere Solutions 9 - Oracle Wire Protocol Driver Setup.

    If you are configuring a new data source, click Add to display a list of installed drivers. Select the Oracle Wire Protocol driver of your choice and click Finish to display the iAnywhere Solutions 9 - Oracle Wire Protocol Driver Setup.

    NOTE: The General tab displays only fields that are required for creating a data source. The fields on all other tabs are optional, unless noted otherwise.

  3. On the General tab, provide the following information and then click Apply.

  4. Optionally, click the Advanced tab to specify data source settings. On this tab, provide any of the following optional information; then, click Apply.

  5. At any point during the configuration process, you can click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box. A logon dialog box is displayed. Note that the information you enter in the logon dialog box during a test connect is not saved. If the driver can connect, it releases the connection and displays a "connection established" message. Click OK. If the driver cannot connect because of an improper environment or incorrect connection value, it will display an appropriate error message. Click OK.


Contents Index Introduction Connecting to a Data Source Using a Logon Dialog Box