Using Open Client with Adaptive Server’s new limits

Adaptive Server and Open Client interact depending on how you determine Open Client’s capabilities. Capabilities describe the types of requests that an application sends on a specific connection and the types of server responses that a server returns on a specific connection. Before you use Open Client with the wider limits allowed by Adaptive Server version 12.5, you must enable the Open Client capability for these limits. See your Open Client documentation for information about enabling the wide-table capabilities.

DB Library cannot use the wide limits for Adaptive Server version 12.5.

Depending on which version of Open Client your site is using, you may have to perform one of the steps below.

Adaptive Server and Open Client both use version 12.5

You should not have any problems if both Adaptive Server and Open Client are at version 12.5. Perform the following before you use Open Client 12.5 with Adaptive Server version 12.5:

  1. Relink your Open Client application with the 12.5 libraries.

  2. Establish the new version number with CS_VERSION.

  3. If you are using jConnect, reconnect the drivers.

Adaptive Server version 12.5 with older Open Client

Open Client connected to a remote Adaptive Server

If you are connecting to a remote Adaptive Server in the manner described below, Open Client does not receive wide data.

Figure 5-1: Open Client connecting to a remote server

In this example, Open Client connects to the 12.5 Adaptive Server using the 12.5 capabilities, but because the database it is querying is in a 12.0 server, the data is returned using the 12.0 limits, and any wide data is truncated.