Help > ODBC Drivers > Excel Driver > Connection String Attributes

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

Attribute	Label	Description
ConnectionStringFile (Setting of ExcelConfigurationParams)	ConnectionStringFile
Cache Settings
CacheEntryTtl (Setting of ExcelConfigurationParams)	Cache entry lifetime, sec	This property indicates how many seconds data is kept in cache (in case caching is enabled)
CacheFileLocation (Setting of ExcelConfigurationParams)	Cache file location	This property allows you to set cache file location (you have to set Cache persistence mode to Storage)
CacheStorage (Setting of ExcelConfigurationParams)	Cache storage	Specifies cache storage - in-memory only or local data file Available Options Option Description Memory Memory File File
CachingMode (Setting of ExcelConfigurationParams)	Cache mode	Enables 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 conversion	Determines 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 level	Sets level of messages logged Available Options Option Description None None Error Error Debug Debug Info Info
LogPath (Setting of ExcelConfigurationParams)	Log file location	Sets 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 automatically 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.
Query Engine Temp Storage
TempStorageMode (Setting of ExcelConfigurationParams)	Intermediate results storage	Use [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.