The following procedure establishes a new data source for the Windows client.
To configure the ODBC client:
1. From the Windows Start menu, choose Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
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.
You are
Description — An optional long description of the data source name. For example, My Accounting Database.
Data Source Name — Identifies the data source configuration name. For example, Accounting.
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: READ COMMITTED, READ UNCOMMITTED, REPEATABLE READ, and SERIALIZABLE. REPEATABLE READ is the default.
The DefaultIsolationLevel setting requires careful consideration. A transaction's isolation level will influence the type of record locks that are applied to records read from the database. The default value for this setting is REPEATABLE READ, unless you specify another setting during configuration. This will instruct the server to apply record SHARE locks, at a minimum, for the duration of a transaction to records read from the database. For most query tools, it is appropriate to set a default level of READ COMMITTED. The default isolation level setting can and will be overridden by applications.
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.
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.
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. For compatibility reasons with OpenEdge Releases 10.X and earlier, character columns are defined as their basic types. For example, a VARCHAR column is defined as the SQL_VARCHAR ODBC type.
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.
Data Source Name — Identifies the data source configuration name. For example, Accounting.
