Connection String Attributes
PreviousNext

Introduction

This page lists all possible attributes you can use in ConnectionString or WITH clause of SQL Query. If you are not sure how to write correct connection string then perform following steps.
  1. Search for odbcad32 in the start menu. Click to launch it.
  2. Configure desired properties in the grid and check Query Preview to make sure everything is correct.
  3. Click on [Copy Connection String] button to generate full connection string.

Connection String Examples

Syntax: (Direct Connection string without DSN)
Driver={ZappySys Jdbc Driver}[,Attribute1=Value;][,Attribute2=Value;]........[,Attribute3=Value;] 
Syntax: (Using DSN)
DSN=YourDsnName;[,Attribute1=Value;][,Attribute2=Value;]........[,Attribute3=Value;]

Connection String Attributes

AttributeLabelDescription
Cache Settings
CacheEntryTtl
(Setting of JdbcConfigurationParams)
Cache entry lifetime, secThis property indicates how many seconds data is kept in cache (in case caching is enabled)
CacheFileLocation
(Setting of JdbcConfigurationParams)
Cache file locationThis property allows you to set cache file location (you have to set Cache persistence mode to Storage)
CacheStorage
(Setting of JdbcConfigurationParams)
Cache storageSpecifies cache storage - in-memory only or local data file

Available Options

Option Description
Memory Memory
File File
CachingMode
(Setting of JdbcConfigurationParams)
Cache modeEnables or disables cache usage for metadata / data

Available Options

Option Description
Disabled Caching disabled
Metadata Cache metadata
All Cache all
Error Handling Settings
ConvErrorHandlingMode
(Setting of JdbcConfigurationParams)
Error handlingDetermines whether some conversion errors are ignored or stop query processing.

Available Options

Option Description
ThrowError Stop execution on error
Ignore Ignore errors
Log Settings
LoggingLevel
(Setting of JdbcConfigurationParams)
Log levelSets level of messages logged

Available Options

Option Description
None None
Error Error
Debug Debug
Info Info
LogPath
(Setting of JdbcConfigurationParams)
Log file locationSets location for the log file (empty value means no log written)
GroupName
(Setting of ColumnsMetadata)
Group name
Metadata Settings
TreatBlankBoolAsNull
(Setting of JdbcConfigurationParams)
Treat blank BOOLEAN value as NULL
TreatBlankDateAsNull
(Setting of JdbcConfigurationParams)
Treat blank DATE/TIME value as NULL
TreatBlankNumberAsNull
(Setting of JdbcConfigurationParams)
Treat blank NUMERIC value as NULL
Output Settings
DefaultRowLimit
(Setting of JdbcConfigurationParams)
Default data row limit (i.e. LIMIT / TOP clause)Use this option if you like to limit number of rows fetched by any query. If you use LIMIT clause in the query then this option is ignored.
Request Settings
ClassName
(Setting of JdbcConfigurationParams)
Driver class
DriverPath
(Setting of JdbcConfigurationParams)
JDBC driver path
JdbcConnectionString
(Setting of JdbcConfigurationParams)
Connection string
UserName
(Setting of JdbcConfigurationParams)
User name
UserPassword
(Setting of JdbcConfigurationParams)
User password


Copyrights reserved. ZappySys LLC.