SAP Knowledge Base Article - Preview

1852558 - Job server fails to connect to the SQL Server when executing the job

Symptom

  • SAP data Services uses a SQL Server data store as a source and target.
  • The data store connection works fine on Designer box and tables and be imported and table data can be viewed in Designer.
  • Data store uses SQL native driver and not ODBC.
  • When the job is executed it throws the following error:

ODBC call <SQLDriverConnect> for data source <database host name> failed: <[Microsoft][ODBC Driver Manager] Data source name 139252 134940 CON-120302 <date time stamp> not found and no defaultdriver specified>. Notify Customer Support.


Read more...

Environment

SAP Data Services

Product

SAP Data Services all versions

Keywords

BODS , DS , driver error not found , KBA , EIM-DS-CON , Data Services Connectivity , 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.