That's because Ignite's ODBC driver does not support all possible connection/statement attributes.
You can try enabling ODBC logging [1], then repeat your actions and send resulted logs to us, so we can see what is the attribute SQL server tries to set that Ignite does not support. [1] - https://www.ibm.com/support/knowledgecenter/en/SSULQD_7.2.1/com.ibm.nz.datacon.doc/t_datacon_enabling_odbc_logging_win.html Best Regards, Igor On Tue, Mar 19, 2019 at 5:20 PM wt <[email protected]> wrote: > Is there a reason the following error is returned by the odbc driver > > OLE DB provider "MSDASQL" for linked server "IGNITE" returned message > "Specified attribute is not supported." > > I am trying to query the odbc driver from SQL server with 2.7. I can see > the > table, the query returns empty columns and this error. Looking at the odbc > code base this error originates from > > > https://github.com/apache/ignite/blob/master/modules/platforms/cpp/odbc/src/connection.cpp > > / case SQL_ATTR_AUTOCOMMIT: > { > SQLUINTEGER mode = > static_cast<SQLUINTEGER>(reinterpret_cast<ptrdiff_t>(value)); > > if (mode != SQL_AUTOCOMMIT_ON && mode != > SQL_AUTOCOMMIT_OFF) > { > > AddStatusRecord(SqlState::SHYC00_OPTIONAL_FEATURE_NOT_IMPLEMENTED, > "Specified attribute is not supported."); > > return SqlResult::AI_ERROR; > } > > autoCommit = mode == SQL_AUTOCOMMIT_ON; > > break; > } > > default: > { > > AddStatusRecord(SqlState::SHYC00_OPTIONAL_FEATURE_NOT_IMPLEMENTED, > "Specified attribute is not supported."); > > return SqlResult::AI_ERROR; > } > }/ > > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
