ASNA dss-setup | 16.0.88.0

ASNA Logo

DataGate for SQL Server release notes

Version: 16.0.88.0 - Generally Available (for production environments)

Release date: 2024-10-10


Users updating from v14 and prior versions of DSS should not activate the new multimember support unless necessary, as it may cause errors.

Installing onto Clustered Servers

DSS can also be installed onto clustered servers by following the instructions detailed in our Installation Guide.

Platform support

See the ASNA Version Policy for full requirements

You can only install one version of an ASNA Windows product on a single PC. For example, you can’t install ASNA Visual RPG for .NET 17.x on a PC on which ASNA Visual RPG for .NET 16.x is installed.

General installation tips

Database Name change

DataGate 17 features secure database name storage using Windows DPAPI.ASNA has always recommended using *PUBLIC database names for websites. In v17, we further recommend always using the *Public prefix explicitly when referencing database names in website applications, including Monarch. Otherwise, applications may encounter run-time exceptions that include phrases such as “user profile not loaded” when Windows DPAPI is used in IIS sessions running with anonymous or impersonated credentials.

For example, an AVR-based website might have code similar to the following, which references a DG database name in a DCLDB statement as follows:

DclDB Name(MyDatabase) DBName("IBMSERVER") Access(*Public)

We strongly recommend changing this statement as shown below:

DclDB Name(MyDatabase) DBName("*Public/IBMSERVER") Access(*Public)

If changing existing code is impractical, the only way to avoid errors is to ensure that the configuration of the IIS application pool in which the website runs includes the setting “Load User Profile = True”.

Note that this setting may reduce the performance of large-scale website applications.

Configuring IIS is Windows- and version-dependent, but generally follows this set of steps:

  1. Open IIS Manager.
  2. Under the Application Pools node, select the Application Pool that the website runs under.
  3. On the right-hand panel, select “Advanced Settings…”. A property dialog appears.
  4. Scroll to the Load User Profile setting, and ensure that it is set to True.
  5. Restart IIS.

Websites may produce “user profile not loaded” exceptions mentioned in the release Notes, even when database names are referenced with the recommended “*Public/” prefix. If so, you must configure the “Load User Profile = True” IIS Application Pool setting (also mentioned in the Release Notes) as a workaround. It is highly recommended to remove this workaround when you install the release of DataGate.

Visual Studio 2022 Editions

Visual Studio 2022 17.4 or higher Professional or Enterprise edition is required with the Papa family.

Secure Sockets Layer (SSL)

The DataGate client software contained in this release significantly changes the way Secure Sockets Layer (SSL) connections are configured. DataGate SSL support was introduced in Version 15 as an option for secure network communications between DataGate clients and servers.

In prior releases, DataGate client connection configurations, by default, specified an SSL-enabled connection. This allowed many users to enhance the security of their applications by simply installing the new, SSL supporting DataGate release. Unfortunately, other customers experienced connection and security issues due to shifting standards and evolving platform infrastructure supporting SSL, as offered by Windows and IBM i.

In this release, DataGate client users must now “opt-in” when configuring new connections secured with SSL. When a new connection configuration is created, the default setting is to specify a non-SSL, or “clear-text” connection to the server.

DataGate connections are typically configured as “database names”. A database name is a collection of properties defining all the information needed to connect to a DataGate server from the client computer. Existing database names are not affected by this change, but new database names are affected:

Database names created by prior releases retain the same SSL configuration as they had when created or modified.

The default configuration of new database names will specify non-SSL connections.

Creating SSL-Enabled Database Names

Online documentation linked below fully details the process of creating an SSL-enabled database name configuration using DataGate Studio. The process is very similar for users of DataGate Monitor.

Read more about DataGate’s SSL support

Other DataGate SSL Options

DataGate offers many options for enhancing the security of its client/server connection with SSL. For full details of options available for both the client and server, please consult the online documentation.

Configuring DataGate Connections Programmatically

Connection configurations are represented in DataGate as instances of the SourceProfile class in the DataGate .NET API. While most users and applications will configure connections via database names, some programs use the DataGate API directly.

Users of the SourceProfile class are advised that the changes in this release may represent a breaking change to the behavior of your programs. The default value of the SourceProfile.SslOptions property is now SslOptions.None; in previous releases the default value was SslOptions.Request. If your program does not explicitly set this property, connections made with the SourceProfile instances you create will be clear-text, rather than SSL-enabled.

If you directly create and use SourceProfile instances in your programs, ASNA highly recommends modifying them to explicitly set SourceProfile.SslOptions before deploying this DataGate release.

Database Name Migration From Non-SSL Releases

Database names created by DataGate releases prior to Version 15 do not contain SSL-related configuration information. When these database names are read by Version 15 software, the configuration is migrated to include SSL configuration options. Prior to this release, those migrations would enable SSL connections, unless otherwise explicitly changed by the user. Henceforth, automatic database name migrations will disable SSL in the connections they represent.

Users who deploy applications using the database names contained in configuration files created with prior, non-SSL supported DataGate releases are advised that changes in this release may represent a breaking change in this deployment strategy, for reasons outlined in the previous paragraph.

Downloading with Microsoft Edge

If this software is downloaded via Edge you may receive a message stating that this file “is not commonly downloaded” when attempting to install it. In this event click the View Downloads button, select the ASNA product to install from that list, and confirm that you’d like to install it.

Similarly, attempting to install the software directly through Microsoft Windows may cause a “Windows protected your PC” message to appear. In this event click the small More Info prompt on the left, and click Run Anyway on the following window.


Changes Since Version: 16.0.83.0

DataGate Studio Clients - DataGate Clients - DataGate Controls Clients - DataGate Monitor DataGate Server