Microsoft SQL Server enhancements

The following enhancements have been made to the Microsoft SQL Server database-related features:

  • The Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) is supported. You can select the MSOLEDBSQL SQL Server interface from Database Profiles to connect to the Microsoft SQL Server 2012, 2014, 2016, 2017, or 2019 databases using the Microsoft OLE DB Driver for SQL Server. The MSOLEDBSQL SQL Server interface supports exactly the same features as the SNC SQL Native Client interface does. The additional new features of Microsoft OLE DB Driver (compared to SQL Native Client) will be supported in the next PowerBuilder version.

    The Microsoft OLE DB Driver for SQL Server 18.2 or later is supported. For more, see the section called “Using Microsoft SQL Server” in Connecting to Your Database.

  • The PowerBuilder application can connect with Microsoft SQL Server database through TLS 1.2 (using either MSOLEDBSQL SQL Server or SNC SQL Native Client interface).