Driver

The Driver tab contains settings for output scenarios.

Table 1. 1010data ODBC driver: Driver tab
ODBC Driver Setting/Linux Keys Default Value Short Description Use Case
Excel(tm) compatibility kludges

{ExcelKludge}
Note: The {ExcelKludge} key does not exist in the Linux config file, but is valid for connection strings in Windows.
Unchecked Required for MS Excel to utilize the ODBC driver for inputting into Excel from 1010data.  
SQL Cancel behavior

{Cancel}
Report Unimplemented Changes the way the ODBC driver reports SQL Cancel functionality. Change this option if you're connecting from MS SQL server.
On error clear cache and retry

{AlwaysClear}
Unchecked Resubmits a query after clearing the server memory cache. If you've encountered an error this command will clear your cache and then resubmit whatever transaction encountered the error exactly once.
ADO SQL Columns underscore kludge

{AdoKludge}
Note: The {AdoKludge} key does not exist in the Linux config file, but is valid for connection strings in Windows.
Unchecked The ADO standard doesn't support underscores ('_') in table names. This allows the user to use a '*' character instead of an '_' character when calling the SQLTables function.  
Report errors in SQLSetStmtAttr

{SetStmtAttr}
Unchecked When this box is chcecked, attempts to set SQL statement attributes will return the following error message: SQL_ERROR, if the attribute cannot be set. If the box is left unchecked, any attempt to set SQL statement attributes will return the message, SQL_SUCCESS, whether the operation was performed successfully or not. This option was created to accomodate the behavior of some tools and the way they connect to the 1010data ODBC driver. Currently, Tableau is the only known tool that requires this option.
String width to report
{StrWidth}
255 This is the width that the 1010data ODBC driver reports for string columns. If your data has very wide string columns you may need to increase this value.