Using this Guide
Part 1: Getting Started
Quick Start Connect
Configuring and Connecting on Windows
Setting the Library Path Environment Variable (Salesforce Driver on Windows)
Configuring a Data Source
Testing the Connection
Configuring and Connecting on UNIX and Linux
Environment Configuration
Test Loading the Driver
Setting the Library Path Environment Variable (Salesforce Driver on UNIX/Linux)
Configuring a Data Source
Testing the Connection
Using the Performance Wizard
Starting the Wizard
Tuning Performance Using the Wizard
Using The Product
What Is ODBC?
How Does It Work?
Why Do Application Developers Need ODBC?
About the Product
Support for Multiple Environments
Environment-Specific Information
For Windows Users
32-Bit Drivers
64-Bit Drivers
Setup of the Drivers
Driver Names
For UNIX and Linux Users
32-Bit Drivers
64-Bit Drivers
AIX
HP-UX 11 aCC
Linux
Oracle Solaris
Setup of the Environment and the Drivers
Driver Names
Using IP Addresses
Binding Parameter Markers
Driver Threading Information
Version String Information
getFileVersionString Function
Retrieving Data Type Information
Persisting a Result Set as an XML Data File
Using the Windows XML Persistence Demo Tool
Using the UNIX/Linux XML Persistence Demo Tool
Translators
Advanced Features
Using Failover
Connection Failover
Extended Connection Failover
Select Connection Failover
Guidelines for Primary and Alternate Servers
Using Client Load Balancing
Using Connection Retry
Summary of Failover-Related Options
A Connection String Example
An odbc.ini File Example
Using Client Information
How Databases Store Client Information
Storing Client Information
Using Security
Authentication
Kerberos Authentication
NTLM Authentication
Data Encryption Across the Network
SSL Encryption
Certificates
SSL Server Authentication
SSL Client Authentication
Summary of Security-Related Options
Using DataDirect Connection Pooling
Creating a Connection Pool
Adding Connections to a Pool
Removing Connections from a Pool
Handling Dead Connections in a Pool
Connection Pool Statistics
Summary of Pooling-Related Options
Using DataDirect Bulk Load
Bulk Export and Load Methods
Exporting Data from a Database
Bulk Loading to a Database
The Bulk Load Configuration File
Bulk Load Configuration File Schema
Verification of the Bulk Load Configuration File
Sample Applications
Determining the Bulk Load Protocol
Character Set Conversions
External Overflow Files
Using Bulk Load for Batch Inserts
Using Bulk Load for Single Inserts/Updates/Deletes (Salesforce Driver)
Summary of Bulk Load Related Options
Configuring the Product on UNIX/Linux
Environment Variables
Library Search Path
ODBCINI
ODBCINST
DD_INSTALLDIR
The Test Loading Tool
Data Source Configuration
Configuration Through the Administrator
Drivers
Tracing
Configuration Through the System Information (odbc.ini) File
Sample Default odbc.ini File
Translators
The demoodbc Application
The example Application
DSN-less Connections
Sample odbcinst.ini File
File Data Sources
UTF-16 Applications on UNIX and Linux
Part 2: The 32-Bit/64-Bit Drivers
The DB2 Wire Protocol Driver
Driver Requirements
Binding
Creating DB2 Packages Using List Files
Creating DB2 Packages Manually
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Accounting Info
Add to Create Table
Alternate ID
Alternate Servers
Application Name
Application Using Threads
Authentication Method
Batch Size
Bulk Binary Threshold
Bulk Character Threshold
Catalog Schema
Character Set for CCSID 65535
Client Host Name
Client User
Collection
Concurrent Access Resolution
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Current Function Path
Data Source Name
Database Name
Default Isolation Level
Description
Dynamic Sections
Enable Bulk Load
Encryption Method
Failover Granularity
Failover Mode
Failover Preconnect
Fetch Time Stamp With Time Zone as Timestamp
Field Delimiter
Grant Execute to [check box]
Grant Execute to [field]
GSS Client Library
Host Name In Certificate
IANAAppCodePage
Ip Address
Key Password
Keystore
Keystore Password
Load Balance Timeout
Load Balancing
Location Name
Login Timeout
Max Pool Size
Min Pool Size
Package Collection
Package Name Prefix
Package Owner
Password
Program ID
Query Timeout
Record Delimiter
Report Codepage Conversion Errors
Tcp Port
Truststore
Truststore Password
Use Current Schema for Catalog Functions
User Name
Validate Server Certificate
With Hold Cursors
XML Describe Type
Performance Considerations
IBM to IANA Code Page Values
Data Types
Using the XML Data Type
Unicode Support
Advanced Features
Failover
Security
Authentication
Connection Pooling
DataDirect Bulk Load
Cursor Stability Isolation Level
XQuery Expressions
Stored Procedure Support
Unexpected Characters
Support for DB2 pureScale
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using Arrays of Parameters
The Informix Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Alternate Servers
Application Using Threads
Cancel Detect Interval
Connection Retry Count
Connection Retry Delay
Database Name
Data Source Name
Description
Host Name
IANAAppCodePage
Load Balancing
Password
Port Number
Server Name
Trim Blank From Index
Use Delimited Identifier
User Name
Performance Considerations
Data Types
Advanced Features
MTS Support
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
The MySQL Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Options Descriptions
Alternate Servers
Application Using Threads
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Data Source name
Database Name
Default Buffer Size for Long/LOB Columns (in Kb)
Description
Enable SQLDescribeParam
Encryption Method
Failover Granularity
Failover Mode
Failover Preconnect
Host
Host Name In Certificate
IANAAppCodePage
Interactive Client
Key Password
Keystore
Keystore Password
Load Balance Timeout
Load Balancing
Login Timeout
Max Pool Size
Min Pool Size
Password
Port Number
Query Timeout
Report Codepage Conversion Errors
Treat Binary Data as Character Data
Truststore
Truststore Password
User Name
Validate Server Certificate
Performance Considerations
Data Types
Unicode Support
Advanced Features
Failover
Security
Connection Pooling
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
The Oracle Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Accounting Info
Action
Alternate Servers
Application Name
Application Using Threads
Array Size
Authentication Method
Batch Size
Bulk Binary Threshold
Bulk Character Threshold
Bulk Options
Cached Cursor Limit
Cached Description Limit
Catalog Functions Include Synonyms
Catalog Options
Client Host Name
Client ID
Client User
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Data Integrity Level
Data Integrity Types
Data Source Name
Default Buffer Size for Long/LOB Columns (in Kb)
Describe at Prepare
Description
Edition Name
Enable Bulk Load
Enable N-CHAR Support
Enable Scrollable Cursors
Enable Server Result Cache
Enable SQLDescribeParam
Enable Static Cursors for Long Data
Enable Timestamp with Timezone
Encryption Level
Encryption Method
Encryption Types
Failover Granularity
Failover Mode
Failover Preconnect
Fetch TSWTZ as Timestamp
Field Delimiter
GSS Client Library
Host
Host Name In Certificate
IANAAppCodePage
Initialization String
Key Password
Keystore
Keystore Password
Load Balance Timeout
Load Balancing
Local Timezone Offset
Lock Timeout
Login Timeout
Max Pool Size
Min Pool Size
Module
Password
Port Number
Procedure Returns Results
Program ID
Query Timeout
Record Delimiter
Report Codepage Conversion Errors
Report Recycle Bin
Server Name
Server Process Type
Service Name
SID
Timestamp Escape Mapping
TNSNames File
Truststore
Truststore Password
Use Current Schema for SQLProcedures
User Name
Validate Server Certificate
Wire Protocol Mode
Performance Considerations
Data Types
XMLType
Examples
Unicode Support
Advanced Features
Failover
Client Information
Security
Authentication
Encryption and Data Integrity
Connection Pooling
DataDirect Bulk Load
Limitations
MTS Support
OS Authentication
Support for Oracle RAC
Support of Materialized Views
Stored Procedure Results
Unexpected Characters
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using Parameter Arrays
The PostgreSQL Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Alternate Servers
Application Using Threads
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Data Source Name
Database Name
Description
Enable Keyset Cursors
Enable SQLDescribeParam
Encryption Method
Extended Column MetaData
Failover Granularity
Failover Mode
Failover Preconnect
Fetch Ref Cursors
Fetch TSWTZ as Timestamp
Fetch TWFS as Time
Host Name
Host Name In Certificate
IANAAppCodePage
Initialization String
Key Password
Key Store
Key Store Password
Keyset Cursor Options
Load Balance Timeout
Load Balancing
Login Timeout
Max Char Size
Max Long Varchar Size
Max Pool Size
Max Varchar Size
Min Pool Size
Password
Port Number
Query Timeout
Report Codepage Conversion Errors
Transaction Error Behavior
Truststore
Truststore Password
User Name
Validate Server Certificate
XML Describe Type
Performance Considerations
Data Types
Using the XML Data Type
Unicode Support
Advanced Features
Failover
Security
Connection Pooling
Stored Procedure Results
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using Arrays of Parameters
The Progress OpenEdge Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Alternate Servers
Connection Retry Count
Connection Retry Delay
Data Source Name
Database Name
Default Isolation Level
Description
Enable Timestamp with Timezone
Encryption Method
Failover Granularity
Failover Mode
Failover Preconnect
Fetch Array Size
Host Name
HostName In Certificate
IANAAppCodePage
Load Balancing
Login Timeout
Password
Port Number
Query Timeout
Truststore
Truststore Password
Use Wide Character Types
User ID
Validate Server Certificate
Performance Considerations
Data Types
Unicode Support
Advanced Features
Failover
Security
Isolation and Lock Levels Supported
SQL Grammar Support
ODBC Conformance Level
Number of Connections and Statements Supported
The SQL Server Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Alternate Servers
Always Report Trigger Results
AnsiNPW
Application Name
Application Using Threads
Authentication Method
Batch Size
Bulk Binary Threshold
Bulk Character Threshold
Bulk Options
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Data Source Name
Database
Description
Domain
Enable Bulk Load
Enable Quoted Identifiers
Encryption Method
Failover Granularity
Failover Mode
Failover Preconnect
Fetch TSWTZ as Timestamp
Fetch TWFS as Time
Field Delimiter
GSS Client Library
Host Name
Host Name In Certificate
IANAAppCodePage
Initialization String
Language
Load Balance Timeout
Load Balancing
Login Timeout
Max Pool Size
Min Pool Size
Packet Size
Password
Port Number
Query Timeout
Record Delimiter
Report Codepage Conversion Errors
Truststore
Truststore Password
Use Snapshot Transactions
User Name
Validate Server Certificate
Workstation ID
XML Describe Type
Performance Considerations
Data Types
Unicode Support
Using the XML Data Type
Advanced Features
Failover
Security
Authentication
Connection Pooling
DataDirect Bulk Load
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
Using The Snapshot Isolation Level
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using Arrays of Parameters
The Sybase Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Alternate Servers
Application Name
Application Using Threads
Authentication Method
Batch Size
Bulk Binary Threshold
Bulk Character Threshold
Charset
Connection Cache Size
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Cursor Positioning for Raiserror
Data Source Name
Database List
Database Name
Description
Default Buffer Size for Long/LOB Columns (in Kb)
Distributed Transaction Model
Enable Bulk Load
Enable Describe Parameter
Enable Quoted Identifiers
Encryption Method
Failover Granularity
Failover Mode
Failover Preconnect
Fetch Array Size
Fetch TWFS as Time
Field Delimiter
GSS Client Library
HA Failover Server Connection Information/Network Address
Host Name In Certificate
IANAAppCodePage
Initialization String
Interfaces File
Language
Load Balance Timeout
Load Balancing
Login Timeout
Max Pool Size
Min Pool Size
Network Address
Packet Size
Password
Prepare Method
Query Timeout
Record Delimiter
Report Codepage Conversion Errors
Select Method
Server Name
Service Principal Name
Tightly Coupled Distributed Transactions
Truncate Time Type Fractions
Truststore
Truststore Password
User Name
Validate Server Certificate
Workstation ID
XA Open String Parameters
Performance Considerations
Data Types
Unicode Support
Advanced Features
Failover
Security
Authentication
Connection Pooling
DataDirect Bulk Load
Bulk Copy Operations and Transactions
Performance Considerations
Unexpected Characters
MTS Support
NULL Values
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Grammar Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using Arrays of Parameters
The Oracle Driver
Driver Requirements
Windows
UNIX and Linux
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Alternate Servers
Application Using Threads
Array Size
Catalog Functions Includes Synonyms
Catalog Options
Client Version
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Data Source Name
Default Buffer Size for Long/LOB Columns (in Kb)
Describe At Prepare
Description
Enable N-CHAR Support
Enable Scrollable Cursors
Enable SQLDescribeParam
Enable Static Cursors For LongData
Enable Timestamp with Timezone
IANAAppCodePage
Load Balance Timeout
Load Balancing
Local Timezone Offset
Lock Timeout
Max Pool Size
Min Pool Size
Optimize Long Performance
Password
Procedure Returns Results
Report Codepage Conversion Errors
Report Recycle Bin
Server List
Server Name
Timestamp Escape Mapping
Use Current Schema for SQLProcedures
User Name
Performance Considerations
Data Types
XMLType
Examples
Unicode Support
Advanced Features
Unexpected Characters
MTS Support
OS Authentication
Support for Oracle RAC
Support of Materialized Views
Stored Procedure Results
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using Arrays of Parameters
The SQL Server Legacy Wire Protocol Driver
Driver Requirements
Windows
UNIX and Linux
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Login Dialog Box
Connection Option Descriptions
Windows
UNIX and Linux
Alternate Servers
AnsiNPW
Application Name
AttachDBFileName
AutoTranslate
Connection Retry Count
Connection Retry Delay
Data Source Name
Database Name
Default User Name
Description
Enable Quoted Identifiers
Fetch TSWTZ as Timestamp
Fetch TWFS as Time
IANAAppCodePage
Language
Load Balancing
Network
PWD
QueryLogFile
QueryLog_On
QueryLogTime
Regional
SAVEFILE
Server
StatsLogFile
StatsLog_On
Use NT Authentication
Use Snapshot Transactions
Workstation ID
Performance Considerations
Data Types
Unicode Support
Advanced Features
Isolation and Lock Levels Supported
Using The Snapshot Isolation Level
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using Arrays of Parameters
Part 3: The 32-Bit Drivers
The Btrieve (Pervasive.SQL) Driver
Driver Requirements
Managing Databases
Transactions
Configuring and Connecting to Data Sources
Using a Connection String
Connection Option Descriptions
Action for Undefined Tables
Application Using Threads
Array Size
Data File Extension
Data Source Name
Database Directory
Default Logon ID
Description
File Open Cache
International Sort
Password
Use Long Qualifiers
Defining Table Structure
Data Types
Indexes
Column Names
Select Statement
Rowid Pseudo-Column
Alter Table Statement
Create and Drop Index Statements
Create Index
Drop Index
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
The dBASE Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
dBASE
FoxPro 3.0 DBC
Using a Connection String
Connection Option Descriptions
Application Using Threads
Cache Size
Create Type [dBASE]
Create Type [FoxPro]
Data File Extension
Data Source Name
Database Directory
Database Name
Description
Extension Case
File Open Cache
IANAAppCodePage
International Sort
Lock Compatibility
Locking
Use Long Names
Use Long Qualifiers
Defining Index Attributes on Windows
Defining Index Attributes on UNIX and Linux
Data Types
Column Names
Select Statement
Rowid Pseudo-Column
Alter Table Statement
Create and Drop Index Statements
Create Index
Drop Index
Pack Statement
SQL Statements for FoxPro 3.0 Database Containers
Locking
Levels of Database Locking
Limit on Number of Locks
How Transactions Affect Record Locks
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
The Informix Driver
Driver Requirements
Windows
UNIX (AIX, HP-UX PA-RISC, and Solaris)
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Application Using Threads
Cancel Detect Interval
Cursor Behavior
Database List
Database Name
Data Source Name
Default User Name
Description
Enable Insert Cursors
Get DB List From Informix (GDBLFI)
Host Name
IANAAppCodePage
Password
Protocol Type
Server Name
Service Name
Trim Blank From Index Name
Use Default Login
Performance Considerations
Data Types
MTS Support
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
The Text Driver
Driver Requirements
Formats for Text Files
Configuring Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Connection Option Descriptions
Action for Undefined Tables
Allow Update And Delete
Application Using Threads
Cache Size
Century Boundary
Column Names in First Line
Data File Extension
Data Source Name
Database Directory
Decimal Symbol
Default Table Type
Delimiter Character
Description
Extension List
File Open Cache
IANAAppCodePage
Include Files with Matching Extensions
International Sort
Rows to Scan
Use Long Qualifiers
Defining Table Structure on Windows
Defining Table Structure on UNIX and Linux
Example of QETXT.INI
Date Masks
Data Types
Select Statement
Alter Table Statement
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
The XML Driver
Driver Requirements
Supported Tabular Formats for XML Documents
Hierarchical-Formatted XML Document Support
Column Data Types
Defining Locations
Specifying Table Names in SQL Statements
Configuring and Connecting to Data Sources
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Data Source Name
Description
Driver Options
International Sort Order
Location Names
Logging
Read Only
Report Codepage Conversion Errors
Schema Mode
Show Manufactured Schemas
Show Virtual Schemas
Configure Location Dialog Box Descriptions
Delete Linked Schema
Flush Every Change
Location
Location Name
Location Type
Max Rows to Scan
Password
Require User ID/Password
Resolve External References
Row Hint
Table Creation
Table Hint
User ID
Validate Schema
Using Hints for Tabular-Formatted XML Documents
Column Mode Identifier
Data Types
Unicode Support
Persisting a Result Set as an XML Data File
ODBC Conformance Level
Number of Connections and Statements Supported
SQL Support
SQL Statements
Extensions to SQL Standards
Grammar Token Definitions
Regular Identifiers
Delimited Identifiers
Integer Numbers
Real Numbers
Character String Literals
GUID Literals
Hex Literals
Time and Date Literals
SQL Operators and Symbols
Keywords for the XML Driver
SQL Comments
Part 4: The Connect XE Drivers
The Greenplum Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Alternate Servers
Application Using Threads
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Data Source Name
Database Name
Description
Enable Keyset Cursors
Enable SQLDescribeParam
Encryption Method
Extended Column MetaData
Failover Granularity
Failover Mode
Failover Preconnect
Fetch RefCursors
Fetch TSWTZ as Timestamp
Fetch TWFS as Time
Host Name
Host Name In Certificate
IANAAppCodePage
Initialization String
Keyset Cursor Options
Key Password
Keystore
Keystore Password
Load Balance Timeout
Load Balancing
Login Timeout
Max Char Size
Max Long Varchar Size
Max Pool Size
Min Pool Size
Max Varchar Size
Password
Port Number
Query Timeout
Report Codepage Conversion Errors
Transaction Error Behavior
Truststore
Truststore Password
User Name
Validate Server Certificate
User Name
XML Describe Type
Performance Considerations
Data Types
Using the XML Data Type
Unicode Support
Advanced Features
Failover
Connection Pooling
Security
Stored Procedure Results
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using Arrays of Parameters
Limitations for Pivotal HAWQ Users
The Impala Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Array Size
Data Source Name
Database
Default Buffer Size for Long/LOB Columns (in Kb)
Default Order By Limit
Description
Enable SQLDescribeParam
Host Name
Login Timeout
Max Varchar Size
Password
Port Number
Remove Column Qualifiers
String Describe Type
Transaction Mode
Use Current Schema for Catalog Functions
User Name
Performance Considerations
Data Types
Materialized Views
Stored Procedures
Unicode Support
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Using Arrays of Parameters
Limitations on Cloudera Impala™ Functionality
The Salesforce Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Application Using Threads
Bulk Load Asynchronous
Bulk Load Batch Size
Bulk Load Concurrency Mode
Bulk Load Poll Interval
Bulk Load Threshold
Bulk Load Timeout
Config Options
Connection Pooling
Connection Reset
Create Database
Data Source Name
Database
Description
Enable Bulk Load
Fetch Size
Field Delimiter
Host Name
Initialization String
JVM Arguments
JVM Classpath
LoadBalance Timeout
Log Config File
Logon Domain
Login Timeout
Max Pool Size
Min Pool Size
Password
Proxy Host
Proxy Password
Proxy Port
Proxy User
Read Only
Record Delimiter
Refresh Dirty Cache
Refresh Schema
Report Codepage Conversion Errors
Security Token
Server Port Number
SQL Engine Mode
Statement Call Limit
Statement Call Limit Behavior
Transaction Mode
User Name
WSFetchSize
WSRetry Count
WSTimeout
Performance Considerations
Data Types
Mapping Objects to Tables
Client-Side Caches
Creating a Cache
Modifying a Cache Definition
Disabling and Enabling a Cache
Refreshing Cache Data
Dropping a Cache
Cache MetaData
Catalog Tables
SYSTEM_CACHES Catalog Table
SYSTEM_CACHE_REFERENCES Catalog Table
SYSTEM_REMOTE_SESSIONS Catalog Table
SYSTEM_SESSIONINFO Catalog Table
SYSTEM_SESSIONS Catalog Table
Timeouts
Views and Remote/Local Tables
Using Identifiers
Database Configuration File
Database
User
UseSchema
Schema
ConfigOptions
SessionOptions
Mapping Objects to Tables
Reports
Connecting Through a Proxy Server
Configuring the SQL Engine Server
Configuring Server Mode
Starting the SQL Engine Server
Stopping the SQL Engine Server
Configuring Java Logging for the SQL Engine Server
Unicode Support
Advanced Features
Failover
Security
Connection Pooling
Parameter Metadata Support
Insert and Update Statements
Select Statements
Using DataDirect Bulk Load With the Salesforce Driver
Error Handling
Driver Errors
Data Source Errors
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
The Sybase IQ Wire Protocol Driver
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Alternate Servers
Application Name
Application Using Threads
Charset
Connection Cache Size
Connection Pooling
Connection Reset
Connection Retry Count
Connection Retry Delay
Cursor Positioning for Raiserror
Data Source Name
Database List
Database Name
Description
Default Buffer Size for Long Columns (in Kb)
Failover Granularity
Failover Mode
Failover Preconnect
Fetch Array Size
Fetch TWFS as Time
HA Failover Server Connection Information/Network Address
IANAAppCodePage
Initialization String
Interfaces File
Language
Load Balance Timeout
Load Balancing
Login Timeout
Max Pool Size
Min Pool Size
Network Address
Packet Size
Password
Query Timeout
Report Codepage Conversion Errors
Select Method
Server Name
Truncate Time Type Fractions
User Name
Workstation ID
Performance Considerations
Data Types
Unicode Support
Advanced Features
Failover
Connection Pooling
Unexpected Characters
NULL Values
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using Arrays of Parameters
The Driver for Apache Hive
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Array Size
Authentication Method
Data Source Name
Database
Default Buffer Size for Long/LOB Columns (in Kb)
Description
Enable SQLDescribeParam
GSS Client Library
Host Name
Login Timeout
Max Varchar Size
Port Number
Proxy User
Remove Column Qualifiers
Service Principal Name
String Describe Type
Transaction Mode
Use Current Schema for Catalog Functions
Use Native Catalog Functions
User Name
Wire Protocol Version
Data Types
Advanced Features
Security
Performance Considerations
Materialized Views
Stored Procedures
Unicode Support
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Using Arrays of Parameters
Limitations on Apache Hive Functionality
The Driver for the Teradata Database
Driver Requirements
Configuring and Connecting to Data Sources
Data Source Configuration in the UNIX/Linux odbc.ini File
Data Source Configuration through a GUI
Using a Connection String
Using a Logon Dialog Box
Connection Option Descriptions
Account String
Authentication Password
Authentication UserId
DBCName List
DBCName or Alias
Default Database
Default Role
Description
Enable Data Encryption
Enable Extended Statement Information
Enable LOBs
Enable Reconnect
IANAAppCodePage
Integrated Security
Login Timeout
Map Call Escape To Exec
Maximum Response Buffer Size
Name
Password
Port Number
ProcedureWithPrintStmt
ProcedureWithSPLSource
Profile
Realm
Report Codepage Conversion Errors
Security Mechanism
Security Parameter
Session Character Set
Show Selectable Tables
TDUserName
UserID
Data Types
Unicode Support
Persisting a Result Set as an XML Data File
Isolation and Lock Levels Supported
SQL Support
ODBC Conformance Level
Number of Connections and Statements Supported
Using this Guide
Number of Connections and Statements Supported
db2general
db2advanced
db2security
db2bind
db2fail
db2cpool
db2bulk
db2bulkexporttable
db2bulkverify
db2bulkloadtable
db2clientmon
db2logon
infwpgeneral
infwpadvanced
infwpfail
informixwplogon
mysqlgeneral
mysqladvanced
mysqlsecurity
mysqlfail
mysqlcpool
mysqllogon
orawpgeneral
orawpadvanced
orawpsecurity
orawpadvsecurity
orawpperform
orawpfail
orawpcpool
orawpbulk
orawpbulkexporttable
orawpbulkverify
orawpbulkloadtable
orawpclientmon
orawplogon
pgsqlgeneral
pgsqladvanced
pgsqlsecurity
pgsqlfail
pgsqlcpool
pgsqllogon
prog10wpgeneral
prog10wpadvanced
prog10wpsecurity
prog10wpfail
prog10wplogon
sqlserwp2general
sqlserwp2advanced
sqlserwp2security
sqlserwp2fail
sqlserwp2cpool
sqlserwp2bulk
sqlserwp2bulkexporttable
sqlserwp2bulkverify
sqlserwp2bulkloadtable
sqlserwp2logon
sybgeneral
sybadvanced
sybsecurity
sybconnection
sybperform
sybfail
sybcpool
sybbulk
sybbulkexporttable
sybbulkverify
sybbulkloadtable
syblogon
orageneral
oraadvanced
oraperform
orafail
oracpool
oralogon
sqlserwpgeneral
sqlserwpadvanced
sqlserwpfail
sqlserwplogon
btrgeneral
btradvanced
btrdefinetable
dbasegeneral
dbaseadvanced
foxgeneral
foxadvanced
dbasedefine
infgeneral
infconnection
infadvanced
informixlogon
textgeneral
textadvanced
textdefine
textparse
d1e146120a1310
d1e146122a1310
xmlgeneral
xmlconlocgeneral
xmlconlocadvanced
xmladvanced
xmloptions
xmllogonhelp
gplumgeneral
gplumadvanced
gplumfail
gplumcpool
gplumsecurity
gplumlogon
impalageneral
impalaadvanced
impalalogon
sfgeneral
sfproxy
sfadvanced
sfsecurity
sfwebservice
sfpool
sfbulk
sfexporttable
sfloadtable
salesforcelogon
sybiqgeneral
sybiqadvanced
d1e190930a1310
sybiqconnection
sybiqperform
sybiqfail
sybiqcpool
sybiqlogon
hiveadvanced
hivegeneral
hivesecurity
hivelogon
terageneral
teraoptions
teraadvanced
teralogon