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 for Me (Login required).

Search for additional results

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