Database parameters and supported database interfaces

The following table lists each supported database interface and the database parameters you can use with that interface in DataWindow Designer and DataWindow .NET.

The database parameters are described in alphabetical order following the table.

Database interface	Database parameters
ADO.NET	ADORelease CommandTimeout CommitOnDisconnect Database DataLink DataSource DateFormat DateTimeFormat DBConfigSection DecimalSeparator DefaultProcOwner DelimitIdentifier DisableBind IdentifierQuoteChar Isolation	Namespace NCharBind (Oracle only) OJSyntax PBCatalogOwner PBMaxBlobSize Provider ProviderString RecheckRows SPCache StaticBind TimeFormat Timeout TrimSpaces TrustedConnection
DIR Sybase DirectConnect™	AppName Async Block (DirectConnect and Adaptive Server Enterprise) CharSet CommitOnDisconnect CursorUpdate DateTimeAllowed DBGetTime DBTextLimit DecimalSeparator DelimitIdentifier FormatArgsAsExp HostReqOwner Language	Locale LowerCaseIdent MaxConnect PacketSize (DIR, SYC) PBCatalogOwner Request ShowWarnings SQLQualifiers StaticBind SystemOwner TableCriteria TrimSpaces TRS UseProcSyntax UTF8
IN9 Informix	Async CommitOnDisconnect DateTimeAllowed DBGetTime DecimalSeparator DelimitIdentifier DisableBind	INET_DBPATH INET_PROTOCOL INET_SERVICE OJSyntax Scroll ThreadSafe
ODBC Using database parameters with ODBC These parameters are supported by the DataWindow Designer ODBC interface only if both the ODBC driver you are using and the back-end DBMS support the feature	Async Block (ODBC, OLE DB, and Oracle) CallEscape CommitOnDisconnect ConnectOption ConnectString CursorLib CursorLock CursorScroll Date DateTime DBGetTime DecimalSeparator DefaultProcOwner DelimitIdentifier DisableBind FormatArgsAsExp	IdentifierQuoteChar LoginTimeOut MsgTerse NumericFormat OJSyntax PacketSize (ODBC) PBCatalogOwner PBNewSPInvocation PBTrimCharColumns PBUseProcOwner RPCRebind SQLCache StaticBind StripParmNames TableCriteria Time TrimSpaces
OLE DB	Block (ODBC, OLE DB, and Oracle) CacheAuthentication CommitOnDisconnect DataLink DataSource DateFormat DateTimeFormat DecimalSeparator DelimitIdentifier DisableBind EncryptPassword IdentifierQuoteChar ImpersonationLevel Init_Prompt IntegratedSecurity LCID Location	MaskPassword Mode OJSyntax PBCatalogOwner PBMaxBlobSize PBTrimCharColumns PersistEncrypted PersistSensitive ProtectionLevel Provider ProviderString RecheckRows ServiceComponents StaticBind TimeFormat Timeout
O84 Oracle 8.x and Oracle8i O90 Oracle9i O10 Oracle 10g	Async BindSPInput Block (ODBC, OLE DB, and Oracle) CnnPool (O90 and later) CommitOnDisconnect ConnectAs (O90 and later) Date DateTime DBGetTime DecimalSeparator DelimitIdentifier DisableBind DisableUnicode (O84 only) FoDelay FoDialog FoRetryCount FormatArgsAsExp MaxFetchBuffer	MixedCase NCharBind (O90 and later) NumbersInternal ObjectMode OJSyntax PackageProcs PBCatalogOwner PWDialog PWExpDialog QualifyPublic SQLCache StaticBind SvrFailover TableCriteria ThreadSafe Time TimeStamp (O90 and later)
SYC Sybase 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.	AppName Async Block (DirectConnect and Adaptive Server Enterprise) CharSet CommitOnDisconnect CursorType CursorUpdate DateTimeAllowed DBGetTime DBTextLimit DelimitIdentifier DS_Alias DS_Copy DS_DitBase DS_Failover DS_Password DS_Principal DS_Provider DS_TimeLimit FoDialog FormatArgsAsExp Host KeepAlive Language Locale Log MaxConnect	OJSyntax PacketSize (DIR, SYC) PBCatalogOwner PWDialog PWEncrypt PWExpDialog Release 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 StaticBind SvrFailover SystemProcs TableCriteria TrimSpaces UTF8

Database interface

Database parameters

ADO.NET

ADORelease
CommandTimeout
CommitOnDisconnect
Database
DataLink
DataSource
DateFormat
DateTimeFormat
DBConfigSection
DecimalSeparator
DefaultProcOwner
DelimitIdentifier
DisableBind
IdentifierQuoteChar
Isolation

Namespace
NCharBind (Oracle only)
OJSyntax
PBCatalogOwner
PBMaxBlobSize
Provider
ProviderString
RecheckRows
SPCache
StaticBind
TimeFormat
Timeout
TrimSpaces
TrustedConnection

DIR Sybase DirectConnect™

AppName
Async
Block (DirectConnect and Adaptive Server Enterprise)
CharSet
CommitOnDisconnect
CursorUpdate
DateTimeAllowed
DBGetTime
DBTextLimit
DecimalSeparator
DelimitIdentifier
FormatArgsAsExp
HostReqOwner
Language

Locale
LowerCaseIdent
MaxConnect
PacketSize (DIR, SYC)
PBCatalogOwner
Request
ShowWarnings
SQLQualifiers
StaticBind
SystemOwner
TableCriteria
TrimSpaces
TRS
UseProcSyntax
UTF8

IN9 Informix

Async
CommitOnDisconnect
DateTimeAllowed
DBGetTime
DecimalSeparator
DelimitIdentifier
DisableBind

INET_DBPATH
INET_PROTOCOL
INET_SERVICE
OJSyntax
Scroll
ThreadSafe

ODBC

Using database parameters with ODBC These parameters are supported by the DataWindow Designer ODBC interface only if both the ODBC driver you are using and the back-end DBMS support the feature

Async
Block (ODBC, OLE DB, and Oracle)
CallEscape
CommitOnDisconnect
ConnectOption
ConnectString
CursorLib
CursorLock
CursorScroll
Date
DateTime
DBGetTime
DecimalSeparator
DefaultProcOwner
DelimitIdentifier
DisableBind
FormatArgsAsExp

IdentifierQuoteChar
LoginTimeOut
MsgTerse
NumericFormat
OJSyntax
PacketSize (ODBC)
PBCatalogOwner
PBNewSPInvocation
PBTrimCharColumns
PBUseProcOwner
RPCRebind
SQLCache
StaticBind
StripParmNames
TableCriteria
Time
TrimSpaces

OLE DB

Block (ODBC, OLE DB, and Oracle)
CacheAuthentication
CommitOnDisconnect
DataLink
DataSource
DateFormat
DateTimeFormat
DecimalSeparator
DelimitIdentifier
DisableBind
EncryptPassword
IdentifierQuoteChar
ImpersonationLevel
Init_Prompt
IntegratedSecurity
LCID
Location

MaskPassword
Mode
OJSyntax
PBCatalogOwner
PBMaxBlobSize
PBTrimCharColumns
PersistEncrypted
PersistSensitive
ProtectionLevel
Provider
ProviderString
RecheckRows
ServiceComponents
StaticBind
TimeFormat
Timeout

O84 Oracle 8.x and Oracle8i

O90 Oracle9i

O10 Oracle 10g

Async
BindSPInput
Block (ODBC, OLE DB, and Oracle)
CnnPool (O90 and later)
CommitOnDisconnect
ConnectAs (O90 and later)
Date
DateTime
DBGetTime
DecimalSeparator
DelimitIdentifier
DisableBind
DisableUnicode (O84 only)
FoDelay
FoDialog
FoRetryCount
FormatArgsAsExp
MaxFetchBuffer

MixedCase
NCharBind (O90 and later)
NumbersInternal
ObjectMode
OJSyntax
PackageProcs
PBCatalogOwner
PWDialog
PWExpDialog
QualifyPublic
SQLCache
StaticBind
SvrFailover
TableCriteria
ThreadSafe
Time
TimeStamp (O90 and later)

SYC Sybase 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.

AppName
Async
Block (DirectConnect and Adaptive Server Enterprise)
CharSet
CommitOnDisconnect
CursorType
CursorUpdate
DateTimeAllowed
DBGetTime
DBTextLimit
DelimitIdentifier
DS_Alias
DS_Copy
DS_DitBase
DS_Failover
DS_Password
DS_Principal
DS_Provider
DS_TimeLimit
FoDialog
FormatArgsAsExp
Host
KeepAlive
Language
Locale
Log
MaxConnect

OJSyntax
PacketSize (DIR, SYC)
PBCatalogOwner
PWDialog
PWEncrypt
PWExpDialog
Release
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
StaticBind
SvrFailover
SystemProcs
TableCriteria
TrimSpaces
UTF8