SAP Knowledge Base Article - Preview

3391475 - Error:' [Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute>' happens when test connection of MSSQL datastore - SAP Cloud Integration for data services

Symptom

  • Test connection of MSSQL datastore failed in CPIDS.
  • Test connection with ODBC Driver 17 for SQL Server 64bit in agent machine with same database is successful.
  • Error:  
    Test failed for the default configuration 'XXX' of datastore: 'XXX': ODBC call <SQLDriverConnect> to connect database <XXX> failed with error: <ODBC call <SQLDriverConnect> for data source <XXX> failed: <[Microsoft][ODBC Driver 17 for SQL Server]
    Invalid connection string attribute>. Notify Customer Support.>. Use the ODBCDriverSelector (Windows) or DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still exists after selecting the correct version of the driver, notify Customer Support. 


Read more...

Environment

  • SAP Cloud Integration for data services
  • SQL Server OnPrem database
  • Agent version 1.0.11.5338 or lower

Product

SAP Cloud Integration for data services 1.0

Keywords

CIDS, CPIDS, invalid connection string attribute, MSSQL, connection failed, test connection , KBA , LOD-HCI-DS-AGNT , On-Premise Agent, Connectivity, Task Run errors , 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.