ODBC Configuration for SQL Anywhere window: Advanced tab

This tab has the following components:

Connection parameter name See...
AppInfo See AppInfo (APP) connection parameter.
CharSet See CharSet (CS) connection parameter.
CommBufferSize See CommBufferSize (CBSIZE) connection parameter.
Compress See Compress (COMP) connection parameter.
CompressionThreshold See CompressionThreshold (COMPTH) connection parameter.
ConnectionName See ConnectionName (CON) connection parameter
Database Switches See DatabaseSwitches (DBS) connection parameter.
DisableMultiRowFetch See DisableMultiRowFetch (DMRF) connection parameter.
Elevate See Elevate connection parameter.
EncryptedPassword See EncryptedPassword (ENP) connection parameter.
Escape Escape connection parameter (ODBC)
Force Start See ForceStart (FORCE) connection parameter.
Idle See Idle connection parameter.
Kerberos See Kerberos (KRB) connection parameter.
Language See Language (LANG) connection parameter.
LazyClose See LazyClose (LCLOSE) connection parameter.
LivenessTimeout See LivenessTimeout (LTO) connection parameter.
LogFile See LogFile (LOG) connection parameter.
NodeType NodeType (NODE) connection parameter
PrefetchBuffer See PrefetchBuffer (PBUF) connection parameter.
PrefetchRows See PrefetchRows (PROWS) connection parameter.
RetryConnectionTimeout See RetryConnectionTimeout (RetryConnTO) connection parameter.

  • Additional connection parameters   Type any additional connection parameters in this field in a semicolon separated list. For example, 
    LOG=connection.log

    Parameters set in this field are superseded by parameters set throughout the rest of this window. For example, if you enter the user ID DBA on the Identification tab, and set the connection parameter "UID=bsmith" in this field, a connection with the user ID DBA is attempted.

    For more information about connection parameters, see Connection parameters and Using connection parameters.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0