The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name. For example:

Application Using Threads

Attribute

ApplicationUsingThreads (AUT)

In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.

Also, a few connection string attributes, for example, Password, do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.

Note: The driver does not support specifying values for the same connection option multiple times in a connection string or DSN. If a value is specified using the same attribute multiple times or using both long and short attributes, the connection may fail or the driver may not behave as intended.

The following table lists the connection string attributes supported by the driver for Apache Cassandra.

Table 1. Apache Cassandra Attribute Names
Attribute (Short Name) Default
ApplicationUsingThreads (AUT) 1 (Enabled)
AsciiSize (ASZ) 4000
AuthenticationMethod (AM) 0 (User Id/Password)
ClusterNodes (CN) None
ConfigOptions (CO) None
CreateMap (CM) 2 (NotExist)
DataSourceName (DSN) None
DecimalPrecision (DP) 38
DecimalScale (DS) 10
Description (n/a) None
FetchSize (FS) 100 (rows)
HostName (HOST) None
IANAAppCodePage (IACP) (UNIX and Linux only) 4 (ISO 8559-1 Latin-1)
InitializationString (IS) None
JVMArgs (JVMA)

For the 32-bit driver:

-Xmx256m

For the 64-bit driver:

-Xmx1024m
JVMClasspath (JVMC) The default is an empty string, which means that the driver automatically detects the CLASSPATHs for all ODBC drivers installed on your machine and specifies them when launching the JVM.
KeyspaceName (KSN) system
LogConfigFile (LCF) None
LoginTimeout (LT) 15
LogonID (UID) None
NativeFetchSize (NFS) 10000 (rows)
Password (PWD) None
PortNumber (PORT) 9042
ReadConsistency (RC) 4 (quorum)
ReadOnly (RO) 0 (Disabled)
ReportCodepageConversionErrors (RCCE) 0 (Ignore Errors)
ResultMemorySize (RMS) -1
SchemaMap (SMP) Default value depends on environment
ServerPortNumber (SPN) For the 32-bit driver:

19934

For the 64-bit driver:

19933
SQLEngineMode (SEM) For Windows:

0 (Auto)

For UNIX/Linux:

2 (Direct)
TransactionMode (TM) 0 (No Transactions)
VarcharSize (VCS) 4000
VarintPrecision (VP) 38
WriteConsistency (WC) 4 (quorum)