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 Excel Driver}[,Attribute1=Value;][,Attribute2=Value;]........[,Attribute3=Value;]
Syntax: (Using DSN) 
DSN=YourDsnName;[,Attribute1=Value;][,Attribute2=Value;]........[,Attribute3=Value;]

Connection String Attributes

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

Available Options

Option Description
Memory Memory
File File
CachingMode
(Setting of ExcelConfigurationParams)		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 ExcelConfigurationParams)		Error handling for data conversionDetermines whether some data conversion errors are ignored or stop query processing.

Available Options

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

Available Options

Option Description
None None
Error Error
Debug Debug
Info Info
LogPath
(Setting of ExcelConfigurationParams)		Log file locationSets location for the log file (empty value means no log written)
LogSize
(Setting of ExcelConfigurationParams)		Maximum log file size (Mb)Sets limit for log file size (0 means no limit, old log entries will be discarded if size limit is reached)
GroupName
(Setting of ColumnsMetadata)		Group name
OverrideMode
(Setting of ColumnsMetadata)		OverrideMode
Metadata Settings
TreatBlankBoolAsNull
(Setting of ExcelConfigurationParams)		Treat blank BOOLEAN value as NULL
TreatBlankDateAsNull
(Setting of ExcelConfigurationParams)		Treat blank DATE/TIME value as NULL
TreatBlankNumberAsNull
(Setting of ExcelConfigurationParams)		Treat blank NUMERIC value as NULL
Other Settings
RowsToScanToGuessMeta
(Setting of ExcelConfigurationParams)		Number of rows to scan to detect column types
Output Settings
DefaultRowLimit
(Setting of ExcelConfigurationParams)		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.
OutputOption
(Setting of ExcelConfigurationParams)		Default Output Option for Insert/Update/DeleteBy default Output=1 for WITH clause in INSERT/UPDATE/DELETE when not specified. Use this option to control default option. This is useful when ODBC Bulk INSERT invoked by some ETL Tools where you cannot supply WITH clause and like to mimic Output=0 so some errors are thrown if some insert records failed. By default when Output=1 then errors not thrown rather displayed in the output as rows.
Query Engine Temp Storage
TempStorageMode
(Setting of ExcelConfigurationParams)		Intermediate results storageUse [Disk] if number of resulting rows or row data size is large

Available Options

Option Description
Memory Memory
Disk Disk
LogLevel
(Setting of ILogger)		LogLevel

Available Options

Option Description
Normal Normal
Summary Summary
Detail Detail
Debugging Debugging
Disabled Disabled
PrefixTimestamp
(Setting of ILogger)		PrefixTimestamp

Copyrights reserved. ZappySys LLC.