SAP Knowledge Base Article - Preview

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

Symptom

  • 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
  • Microsoft SQL Server

Product

SAP Data Services all versions

Keywords

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