2. Click the User DSN tab or the System DSN tab to list user or system data sources, respectively.
3. To configure a new data source, click the Add button. A list of installed drivers appears. Select DataDirect OpenAccess SDK 8.1 - Local; then, click Finish.
Note:To change an existing data source, select the data source you want to configure and click the Configure button.
4. The DataDirect OpenAccess SDK Local ODBC Driver Setup dialog box appears.
On the General tab, provide the following information; then, click Apply.
Data Source Name: Type a unique name that identifies this ODBC data source configuration. Examples are Accounting or OpenAccess to Accounting Data.
Description: Optionally, type a description of the data source, for example, My Accounting Database.
Service Name: Type the name of an OpenAccess SDK service defined in the configuration file (install_dir\cfg\oadm.ini). For information about using the configuration file, refer to the OpenAccess SDK Administrator’s Guide.
Service Data Source: Type the name of an OpenAccess SDK server data source configured for the OpenAccess SDK service to use for the connection, or click the browse button to select an existing server data source. This field is optional. If a server data source is not specified, the default server data source for that service is used.
Custom Properties: (Optional) Type a custom property and value directly to the IP layer. The custom connection properties are key=value pairs, separated by semicolons:
Translate: Click this button to display the Select Translator dialog box, which lists the translators specified in the ODBC Translators section of the Registry.
Select a translator; then, click OK to close this dialog box and perform the translation.
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 appears; see Specifying ODBC Connection Attributesfor details.
Note: 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 displays an appropriate error message. Click OK.
Note: If you are configuring alternate servers for use with the connection failover feature, be aware that the Test Connect button tests only the primary server, not the alternate servers.
6. Click OK or Cancel. If you click OK, the values you have specified become the defaults when you connect to the data source. You can change these defaults by using this procedure to reconfigure your data source. You can override these defaults by connecting to the data source using a connection string with alternate values.
