- AppDriverName
- AppName
- Async
- BindSPInput
- BinTxtBlob
- Block (ODBC, OLE DB, Oracle, and SNC)
- Block (Adaptive Server Enterprise)
- CacheAuthentication
- CacheGroup
- CacheName
- CallEscape
- CharSet
- Client_Locale
- CnnPool
- CommandTimeout
- CommitOnDisconnect
- ConnectAs
- ConnectOption
- ConnectString
- CSIncr
- CSMax
- CSMin
- CursorLib
- CursorLock
- CursorScroll
- CursorType
- CursorUpdate
- Database
- DataLink
- DataSource
- Date
- DateFormat
- DateTime
- DateTimeAllowed
- DateTimeFormat
- DBGetTime
- Db_Locale
- DBTextLimit
- DecimalSeparator
- DefaultProcOwner
- DelimitIdentifier
- DelimitIdentifierToDB
- DisableBind
- DS_Alias
- DS_Copy
- DS_DitBase
- DS_Failover
- DS_Password
- DS_Principal
- DS_Provider
- DS_TimeLimit
- Encrypt
- EncryptionPass
- EncryptPassword
- FailoverPartner
- FoDelay
- FoDialog
- FoRetryCount
- FormatArgsAsExp
- GenerateEqualsNull
- HANotification
- HighSeverityError
- Hint
- Host
- IdentifierQuoteChar
- Identity
- ImpersonationLevel
- INET_DBPATH
- INET_PROTOCOL
- INET_SERVICE
- Init_Prompt
- InsertBlock
- IntegratedSecurity
- Isolation
- KeepAlive
- Language
- LCID
- Locale
- Location
- Log
- LoginTimeOut
- LongConnection
- MaskPassword
- MaxConnect
- MaxFetchBuffer
- MixedCase
- Mode
- MsgTerse
- NCharBind
- NCharLiteral
- NLS_Charset
- NumbersInternal
- NumericFormat
- ObjectMode
- OJSyntax
- OnlineIndex
- OraMTSConFlgs (obsolete)
- PackageProcs
- PacketSize (ODBC)
- PacketSize (ASE, SNC, SYC)
- PBCatalogOwner
- PBMaxBlobSize
- PBMaxTextSize
- PBNewSPInvocation
- PBNoCatalog
- PBTrimCharColumns
- PBUseProcOwner
- PersistEncrypted
- PersistSensitive
- PoolCreator
- Pooling
- PoolPwd
- ProcedureInTransaction
- ProtectionLevel
- Provider
- ProviderString
- PWDialog
- PWEncrypt
- PWExpDialog
- QualifyPublic
- RecheckRows
- Release
- RPCRebind
- ReturnCommandHandle
- RTConnBalancing
- Scroll
- Sec_Channel_Bind
- Sec_Confidential
- Sec_Cred_Timeout
- Sec_Data_Integrity
- Sec_Data_Origin
- Sec_Delegation
- Sec_Keytab_File
- Sec_Mechanism
- Sec_Mutual_Auth
- Sec_Network_Auth
- Sec_Replay_Detection
- Sec_Seq_Detection
- Sec_Server_Principal
- Sec_Sess_Timeout
- ServerName
- ServiceComponents
- SessionHomogeneous
- ShowTempTables
- SPCache
- SQLCache
- StatementCache
- StaticBind
- StmtCache
- StrByCharset
- StripParmNames
- SvrFailover
- SystemProcs
- TableCriteria
- ThreadSafe
- Time
- TimeFormat
- Timeout
- TimeStamp
- TrimSpaces
- TrustedConnection
- TrustServerCertificate
- UnicharBind
- UTF8
The following table lists each supported database interface and the database parameters you can use with that interface in PowerBuilder. The database parameters are described in alphabetical order after the table.
|
Database interface |
DBParm parameters |
|
|---|---|---|
|
ADO.NET |
NCharBind (Oracle only) |
|
|
ASE SAP Adaptive Server Enterprise Release The Release database parameter must be set to 15 or higher to use the ASE interface. |
ProxyUserName (obsolete) |
|
|
IN9 Informix |
||
|
I10 Informix |
||
|
ODBC Using DBParms with ODBC These database parameters are supported by the PowerBuilder ODBC interface only if both the ODBC driver you are using and the back-end DBMS support the feature |
Block (ODBC, OLE DB, Oracle, and SNC) GetConnectionOption (obsolete) |
ODBCU_CONLIB (obsolete) ProxyUserName (obsolete) ReleaseConnectionOption (obsolete) UseContextObject (obsolete) |
|
OLE DB |
||
|
ORA Oracle (for 11g and later) O10 Oracle 10g Oracle 9.2 |
AppDriverName (ORA only) Block (ODBC, OLE DB, Oracle, and SNC) CnnPool (obsolete) CSIncr (ORA only) CSMax (ORA only) CSMin (ORA only) GetConnectionOption (obsolete) HANotification (O10 and later) NCharLiteral (O10 and later) |
PoolCreator (ORA only) Pooling (ORA only) PoolPwd (ORA only) ReleaseConnectionOption (obsolete) RTConnBalancing (ORA only) ServerName (ORA only) SessionHomogeneous (ORA only) StatementCache (O10 and later) UseContextObject (obsolete) |
|
SNC SQL Native Client for Microsoft SQL Server MSOLEDBSQL Microsoft OLE DB Driver for SQL Server |
||
|
SYC SAP Adaptive Server Enterprise Set Release The Release database parameter must be set to the version of your Open Client software (11 or higher) to use DS_* and Sec_* parameters. |
ProxyUserName (obsolete) |
