New database parameters
Provider parameter
The Provider DBParm parameter for the SQL Server (MSOLEDBSQL)
interface can connect to various versions including SQL Server 2014,
2016, 2017, 2019, and 2022.
The Provider DBParm parameter for the SQL Native Client (SNC)
interface allows you to select the SQL Server version that you want to
connect to. You can set this parameter in script to SQLNCLI (for the SNC
9.0 driver that connect to SQL Server 2005), to SQLNCLI10 (for the SNC
10.0 driver that connects to SQL Server 2008), or to SQLNCLI11 (for the
SNC 11.0 driver that connects to SQL Server 2014 or later). Otherwise,
you can select one of these providers on the Connection tab of the
Database Profile Setup dialog box for the SNC interface.
If you do not set or select a provider, the default selection is
SQLNCLI (SNC 9.0 for SQL Server 2005). This allows existing SNC
interface users to be able to upgrade to PowerBuilder without any
modifications. If PowerBuilder fails to connect with the SQLNCLI
provider, it will attempt to connect to SQLNCLI10 provider. However, if
you explicitly set the provider and the connection fails, PowerBuilder
displays an error message.
Failover parameter
The Failover Partner DBParm parameter allows you to set the name
of a mirror server, thereby maintaining database availability if a
failover event occurs. You can also set the name of the mirror server on
the System tab of the Database Profile Setup dialog box for the
MSOLEDBSQL or SNC interface.
When failover occurs, the existing PowerBuilder connection to SQL
Server is lost. The MSOLEDBSQL or SNC driver releases the existing
connection and tries to reopen it. If reconnection succeeds,
PowerBuilder triggers the failover event.
The following conditions must be satisfied for PowerBuilder to
trigger the failover event:
-
The Failover Partner DBParm is supplied at connect time
-
The SQL Server database is configured for mirroring
-
PowerBuilder is able to reconnect successfully when the
existing connection is lost
When failover occurs:
-
PowerBuilder returns an error code (998) and triggers the
failover event -
Existing cursors cannot be used and should be closed
-
Any failed database operation can be tried again
-
Any uncommitted transaction is lost. New transactions must be
started