SAP Knowledge Base Article - Preview

3587243 - Failed Connectivity from Microsoft SQL Server to SAP Data Services 4.x

Symptom

The job execution fails with below error when trying to establish connectivity from SAP Data Services 4.3 to MS SQL Server 2017:

ODBC call <SQLDriverConnect> for data source <DS_example> failed: <[SAP BODS][ODBC SQL Server Wire Protocol driver]Timeout expired. select failed: 0 [SAP BODS][ODBC SQL Server Wire Protocol driver]Invalid attribute in connection string: DriverUnicodeType.>. Notify Customer Support 


Read more...

Environment

  • Windows 2016 
  • Data Services 4.3 
  • SQL Server 2017

Product

SAP Data Services 4.2 ; SAP Data Services 4.3

Keywords

SAP Data Services, SQL Server, Connectivity, Job Execution, ODBC, DSN, Linux, Windows, Database, Datastore, Error, CON-120302, Timeout, SQLDriverConnect, DriverUnicodeType, Timeout expired, ODBC SQL Server Wire Protocol driver. , KBA , EIM-DS-CON , Connectivity , EIM-DS , Data Services , EIM-DS-EXE , Job Execution , EIM-DS-DES , User Interface/Designer , 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.