1514119 - Error: "CON-120302...ODBC call <SQLDriverConnect> failed...Data source name not found and no default driver specified - DS and IS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

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.

Read failed...Data source name not found and no default driver specified - DS and IS">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 4.0 ; SAP Data Services XI 3.2 ; 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 (Use Subcomponent) , EIM-IS , Information Steward (Use Subcomponent) , 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.