Migrating from the MSS or OLE DB database interfaces – PB Docs 2021

In earlier releases of PowerBuilder, the MSS native interface was
provided for connection to Microsoft SQL Server. This native interface was
based on Microsoft DB-LIB functionality, which is no longer supported by
Microsoft and is not Unicode-enabled. The MSS interface was removed in
PowerBuilder 10.0.

Prior to the introduction of SQL Server 2005 and SQL Native Client,
Microsoft recommended using the OLE DB database interface and MDAC to
connect to SQL Server. You can continue to use this solution if you do not
need to take advantage of new features in SQL Server 2005 or later
versions.

This section provides a comparison between database parameters you
might have used in existing applications with the parameters you can use
with the MSOLEDBSQL and SNC database interfaces.

MSS database parameters supported by
MSOLEDBSQL and SNC

The following table shows the database parameters and preferences
that could be set in the Database Profile Setup dialog box for the
discontinued MSS native database interface for Microsoft SQL Server, and
indicates whether they are supported by the MSOLEDBSQL and SNC
interfaces.

The column on the left shows the tab page in the Database Profile
Setup dialog box for MSS. The parameters and preferences may be on
different tab pages in the MSOLEDBSQL or SNC profile.

OLE DB database parameters supported by
MSOLEDBSQL and SNC

The following table shows the database parameters and preferences
that can be set in the Database Profile Setup dialog box for the OLE DB
standard interface for Microsoft SQL Server, and indicates whether they
are supported by the MSOLEDBSQL and SNC interfaces.

The column on the left shows the tab page in the Database Profile
Setup dialog box for OLE DB. The parameters and preferences may be on
different tab pages in the MSOLEDBSQL or SNC profile.

Additional database
parameters

The MSOLEDBSQL and SNC interfaces also support the ReCheckRows and
BinTxtBlob runtime-only parameters, the Encrypt, TrustServerCertificate,
and SPCache parameters (on the System tab page), and the Identity
parameter (on the Syntax tab page).

SPCache database parameter

You can control how many stored procedures are cached with parameter
information by modifying the setting of the SPCache database parameter.
The default is 100 procedures. To turn off caching of stored procedures,
set SPCache to 0.

For more information about database parameters supported by the
MSOLEDBSQL and SNC interfaces, see the section called “Database preferences and supported database interfaces” in Connection Reference.