SAP Knowledge Base Article - Preview

2928766 - ODBC error: connected: 1 state: HY024 code: 0 [Microsoft][ODBC Driver 17 for SQL Server]Invalid attribute value

Symptom

Setting up SDA connection to HANA from MS-SQL Server 2008 R2 generated the below error.

FedTrace odbcaccess.cpp(01241) : Connection attribute SQL_ATTR_CONNECTION_DEAD checked. Returned code: 0, closed: 0
FedTrace odbcaccess.cpp(03781) : ODBC error: connected: 1 state: HY024 code: 0 [Microsoft][ODBC Driver 17 for SQL Server]Invalid attribute value
FedTrace odbcaccess.cpp(02803) : SetReadOnly(value=0) (retcode=-1)
FedTrace FederationContext.cpp(01497) : FederationException created 0x00007fb53755d580: Exception 10002: (XXXXXX) [Microsoft][ODBC Driver 17 for SQL Server]Invalid attribute value
FedTrace FederationRdes.cpp(00161) : Disconnect from server: XXXXXXXXXX


Read more...

Environment

SAP HANA Platform Edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

Load Balancer, ODBC, Clustering , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.