The following procedure establishes a new data source for the Windows client.

To configure the ODBC client:

  1. From the Windows Start menu, search for ODBC Data Sources (64-bit) and launch the application.
    The ODBC Data Source Administrator dialog box appears:

  2. Click Add to display a list of installed drivers.

    The Create New Data Source dialog box appears.
  3. Highlight the Progress OpenEdge <version number> driver, then click Finish. :

    The Progress OpenEdge Wire Protocol Driver Setup dialog box appears:

  4. Specify values for the following:
    • Data Source Name — Identifies the data source configuration name. For example, Accounting.
    • Description — An optional long description of the data source name. For example, My Accounting Database.
    • Host Name — The name of the system where the database or database broker is located.
    • Port Number — The system port number setup for the database listener process.
    • Database Name — The name of the database to which you want to connect by default.
    • User ID — The default logon ID (user name) used to connect to your OpenEdge database. Your ODBC application can override this value or you can override it in the Logon dialog box or connection string.
  5. From the Progress OpenEdge Wire Protocol Driver Setup dialog box, click the Advanced tab.

    The Advanced tab dialog box appears:

  6. Specify values for the following:
    • Default Isolation Level — Specifies the default isolation level for concurrent transactions. Choose from the following values:
      • 0-READ UNCOMMITTED
      • 1-READ COMMITTED
      • 2-REPEATABLE READ
      • 3-SERIALIZABLE
      The Default Isolation Level setting requires careful consideration. The isolation level of a transaction influences the type of record locks that are applied to records read from the database. The default value for this setting is 1-READ COMMITTED, unless you specify another setting during configuration. For most query tools, setting 1-READ COMMITTED as the default isolation level is optimal. It instructs the server to apply record SHARE locks, at a minimum, for the duration of a transaction to records read from the database. The default setting for isolation level can and will be overridden by applications. See Data control language and transaction behavior for an explanation of the SET TRANSACTION ISOLATION LEVEL command.
    • Fetch Array Size — The number of rows the driver retrieves when fetching from the server. This is not the number of rows given to the user. The default is 50.
    • Login Timeout — Specifies number of seconds the driver waits for a connection to be established before returning control to the application and generating a timeout error. The default duration is 15 seconds.
    • Query Timeout — Specifies the number of seconds for the default query timeout for all statements that are created by a connection. The default value is 0, which means the query does not timeout.
    • Lock Wait Timeout — Specifies the number of seconds the driver waits to execute an OpenEdge process when encountering a locked resource. The default value is 0, which means the driver fails to execute an OpenEdge process immediately when encountering a locked resource.
    • Enable Timestamp with Time Zone — Select this check box to expose timestamps with time zones to the application. By default, the check box is selected.

      When selected, the format is: YYYY-MM-DD HH:MM:SS.SSS+HH:MM.

      The equivalent connection string attribute is EnableTimestampWithTimezone.

    • TCP Keep Alive — Specifies whether the driver enables TCPKeepAlive. TCPKeepAlive maintains idle TCP connections by periodically passing packets between the client and server. If either the client or server does not respond to a packet, the connection is considered inactive and is terminated. In addition, TCPKeepAlive prevents valid idle connections from being disconnected by firewalls and proxies by maintaining network activity.
    • Use Wide Character Types — With this option enabled, character columns are defined as ODBC Unicode/wide types. For example, a VARCHAR column is defined as the SQL_WVARCHAR ODBC type.
    • Extended Options — An expandable section for specifying additional configuration options thatmay be specific to the driver or database.

      For more information, see “Connection option descriptions” in the DataDirect Documentation.

  7. Click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box.

    If the driver can connect, it releases the connection and displays a connection established message.
Note:
  • With the upgrade of the Progress OpenEdge ODBC driver from version 07.16.0304 to 08.02.0293 in OpenEdge Release 12.2.18, the driver file name has changed from pgoe27.dll to pgoe28.dll. Therefore, you must first remove the existing Data Source Name (DSN) and create a new DSN to align with the new driver settings by repeating the steps in the preceding section.
  • You must have Microsoft Visual C/C++ runtime version 14.40.33810 or later on your machine to run the driver.