skip to main content
Configuring the ODBC Client : Configuring Data Sources for the Local ODBC Client on Windows : Configuring ODBC User and System Client Data Sources
 

Configuring ODBC User and System Client Data Sources

1. Start the ODBC Administrator. Select Start / Programs / Progress DataDirect OpenAccess SDK 8.1. Then, select Local Client for ODBC and IP SDK / ODBC Administrator.
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.
The DataDirect OpenAccess SDK Local ODBC Driver Setup window appears.
DataDirect OpenAccess SDK Local ODBC Driver Setup window
4. 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 a service defined in the configuration file (install_dir\cfg\oadm.ini), or click the ... button to select an existing service.
Service Data Source: Type the name of a server data source configured for the OpenAccess SDK service to use for the connection, or click the ... 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:
([;attribute=value[;attribute=value]...])
You can enter up to 16383 characters.
Refer to the OpenAccess SDK Client Reference for information about using custom properties.
Translate: Click Translate 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 Connecting to an ADO Data Source for details.
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 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.