SAP Knowledge Base Article - Preview

1514119 - Error: "CON-120302...ODBC call <SQLDriverConnect> failed...Data source name not found and no default driver specified - SAP Data Services and Information Steward

Symptom

  • Error when running Data Services (DS) batch job: 

    CON-120302 | Session Test ODBC call <SQLDriverConnect> for data source <DatabaseServerName> failed: <[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified>. Notify Customer Support.


  • Error when running Information Steward (IS) profiling task (error in the tracelog in the Data Services Log\<job_server>\<repository> folder):

    CON-120302: Initialization ODBC call <SQLDriverConnect> for data source <DatabaseServerName\InstanceName> failed: <[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.>. Notify Customer Support.


failed...Data source name not found and no default driver specified - SAP Data Services and Information Steward"> Read more...

Environment

  • Data Services 3.2 on Windows 2003
  • Data Services 4.0 on Windows 2003
  • Information Steward 4.0 - Data Insight functionality via Data Services
  • Microsoft SQL Server 2005 client on the Designer machine (Windows 2003)
  • Microsoft SQL Server 2008 database installed on Windows 2008

Product

SAP Data Services all versions ; SAP Information Steward 4.0

Keywords

BODI, BODS, DSXI, DI, DS, XI, MS, profiler, column, columns, SQL Server, Native Client, con 120302 , KBA , EIM-DS , Data Services , EIM-IS , Information Steward , 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.