ODBC Driver for Microsoft Excel

Build 24.0.8963

IncludeDualTable

Set this property to mock the Oracle DUAL table for better compatibility with Oracle database.

Data Type

bool

Default Value

false

Remarks

Set this property to mock the Oracle DUAL table. This table is used by Oracle database in a few special cases. This property facilitates connectivity when accessing Microsoft Excel as a remote Oracle database through the ODBC Gateway. For example, in SQL Developer, this table is queried to test the connection.

When using the ODBC Gateway, set the following properties, as well:

MapToWVarchar=False Set this property to map string data types to SQL_VARCHAR instead of SQL_WVARCHAR. By default, the driver uses SQL_WVARCHAR to accommodate various international character sets. You can use this property to avoid the ORA-28528 Heterogeneous Services data type conversion error when the Unicode type is returned.
MaximumColumnSize=4000 Set this property to restrict the maximum column size to 4000 characters.
UpperCaseIdentifiers=True Set this property to avoid quoting identifiers. Use this property to report uppercase identifiers to Oracle. By default, Oracle stores identifiers in uppercase, so uppercase identifiers do not need to be escaped with quotes.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963