Additional connection options

The tabbed pages in the Database Profile Setup – Sybase Adaptive
Server Enterprise dialog box include additional options that you
can set if desired to fine-tune your database connection and take
advantage of DBMS-specific features that the Sybase Adaptive Server
Enterprise interface supports. Each connection option corresponds
to a DBParm parameter or (for Isolation Level and AutoCommit Mode)
SQLCA property that can be set in a PowerBuilder application script
by copying its syntax from the Preview
tab (PowerBuilder only).

The following tables list the connection options on each tabbed
page and their corresponding DBParm parameter or SQLCA property.
Click the DBParm or SQLCA property for a complete description.

The options marked with an asterisk ( * ) are
not relevant to the SYJ database interface.

Connection
tab

Option	DBParm parameter or SQLCA property
Release (For ASE driver, must be set to 15)*	Release
Isolation Level	Lock
AutoCommit Mode	AutoCommit
Commit on Disconnect	CommitOnDisconnect
Displays Runtime Dialog When Password Expires	PWDialog

Regional
Settings tab

Option	DBParm parameter or SQLCA property
Language *	Language
Character Set *	CharSet
Locale *	Locale
UTF-8 Character Set Installed or Unicode Conversions Enabled in Server *	UTF8

System
tab

Option	DBParm parameter or SQLCA property
Log Text and Image Updates	Log
Display System Stored Procedures	SystemProcs
PowerBuilder Catalog Table Owner	PBCatalogOwner
Table Criteria *	TableCriteria
Show Temp Tables *	ShowTempTables

Transaction
tab

Option	DBParm parameter or SQLCA property
Asynchronous *	Async
Number of Seconds to Wait *	DBGetTime
Static Bind	StaticBind
Disable Bind	DisableBind
Bind String parameters as Unichar type	UnicharBind
Retrieve Blocking Factor	Block (DirectConnect and Adaptive Server Enterprise)
Cursors Declared Updatable	CursorUpdate
Read Only Cursor Type	CursorType

Syntax
tab

Option	DBParm parameter or SQLCA property
Enclose Table and Column Names in Quotes	DelimitIdentifier
DateTime Datatype Allowed	DateTimeAllowed
Format Arguments in Scientific Notation	FormatArgsAsExp
Text Limit in SQL	DBTextLimit
Trim Trailing Spaces in CHAR data	TrimSpaces
Outer Join Syntax	OJSyntax

Network
tab

Option	DBParm parameter or SQLCA property
Application Name *	AppName
Workstation Name *	Host
Packet Size *	PacketSize (ASE, DIR, SNC, SYC)
Maximum Client Library Connections *	MaxConnect
Keep Connection Alive *	KeepAlive
Encrypt Password *	PWEncrypt
Allow Server Failover	SvrFailover

Security
tab

Option	DBParm parameter or SQLCA property
Security Mechanism *	Sec_Mechanism
Server Principal Name *	Sec_Server_Principal
Session Timeout *	Sec_Sess_Timeout
Credential Timeout *	Sec_Cred_Timeout
Mutual Authentication *	Sec_Mutual_Auth
Network Based Authentication *	Sec_Network_Auth
Use Delegated Credentials *	Sec_Delegation
Enable Channel Binding *	Sec_Channel_Bind
Keytab File *	Sec_Keytab_File
Encrypt All Results *	Sec_Confidential
Ensure Data Integrity *	Sec_Data_Integrity
Verify Packet Origin *	Sec_Data_Origin
Detect Replayed Commands *	Sec_Replay_Detection
Detect Sequence Errors *	Sec_Seq_Detection

Directory
Services tab

Option	DBParm parameter or SQLCA property
Provider *	DS_Provider
DIT Base *	DS_DitBase
Principal Name *	DS_Principal
Password (Adaptive Server Enterprise 12.5 or higher) *	DS_Password
Directory Search Time Limit *	DS_TimeLimit
Enable Failover *	DS_Failover
Use Caching *	DS_Copy
Directory Alias Entries *	DS_Alias

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 15.0

August 20, 2023

Was this article helpful?

Connection Information

Additional connection options – PB Docs 150