Powerbuilder Connection Reference

PersistEncrypted – PB Docs 2017

PersistEncrypted database parameter Description Specifies whether the data source you are accessing through the OLE DB interface is allowed to save your encrypted password. When to specify PersistEncrypted You must specify the PersistEncrypted parameter before connecting to the database. Applies to OLE DB Syntax

Parameter Description value Specifies whether the data source can save your…

RTConnBalancing – PB Docs 2017

RTConnBalancing database parameter Description Supports the runtime connection load balancing feature. Applies to ORA Oracle 11g Syntax

Parameter Description value Specifies whether the load balancing feature is used. Values are: True (Default) The load balancing feature is used if session pooling is set. False The load balancing feature is not used. Default value True,…

Isolation – PB Docs 2017

Isolation database parameter Description Sets the isolation level to use when connecting to the database. In multiuser databases, transactions initiated by different users can overlap. If these transactions access common data in the database, they can overwrite each other or collide. To prevent concurrent transactions from interfering with each other and compromising the integrity of…

PersistSensitive – PB Docs 2017

PersistSensitive database parameter Description Specifies whether the data source you are accessing through the OLE DB interface is allowed to save sensitive authentication information, such as a password, along with other authentication information. When to specify PersistSensitive You must specify the PersistSensitive parameter before connecting to the database. Applies to OLE DB Syntax

Parameter Description…

KeepAlive – PB Docs 2017

KeepAlive database parameter Description Determines whether packets are sent to the database to ensure that the connection is still active. When to specify KeepAlive You must specify the KeepAlive parameter before connecting to the database. Applies to ASE, SYC SAP Adaptive Server Enterprise Syntax

Parameter Description value Specifies whether the Open Client/Server CS_CON_KEEPALIVE property…

MsgTerse – PB Docs 2017

MsgTerse database parameter Description Specifies whether PowerBuilder should display terse error messages for JDBC or ODBC drivers. A terse error message is one without the SQLSTATE=nnnn prefix, where nnnn is the number of the error message.  By default, PowerBuilder displays JDBC and ODBC error messages with the SQLSTATE prefix. To display error messages without the SQLSTATE prefix, set…

Namespace – PB Docs 2017

Namespace database parameter Description Specifies the .NET Framework data provider to be used to access data. When to specify Namespace You must specify the Namespace parameter before connecting to the database. Applies to ADO.NET Syntax

Parameter Description value Specifies a namespace to be used as the data provider for an ADO.NET connection. Supported namespaces…

NCharBind – PB Docs 2017

NCharBind database parameter Description Specifies whether PowerBuilder binds input string parameters to the Char or NChar datatype. Applies to ADO.NET (Oracle.DataAccess.Client only) O90 Oracle9i O10 Oracle 10g ORA Oracle 11g SNC SQL Native Client for Microsoft SQL Server Syntax

Parameter Description value Specifies whether PowerBuilder binds string input parameters to the Char or NChar datatype. Values are: 0…

ReturnCommandHandle – PB Docs 2017

ReturnCommandHandle database parameter Description Specifies whether you want PowerBuilder to return a handle to a session object or a data source object when you call the DBHandle function. Applies to OLE DB Syntax

Parameter Description value Specifies whether you want PowerBuilder to return a handle to a session object or a data source object….

NCharLiteral – PB Docs 2017

NCharLiteral database parameter Description Specifies whether the NChar literal replacement feature in the Oracle client is enabled. This feature replaces string literals on the client that are prefaced with the letter N with an internal format. The internal format is decoded to Unicode by the database server when the statement is executed. When to specify…