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.