SAP Knowledge Base Article - Preview

1866869 - SBOP BI 4.0: Error: "Data source name not found and no default driver specified" when creating Multi-source enabled Data Foundation with 32-bit and 64-bit data providers in Information Design Tool

Symptom

  • Relational connection over 32-bit ODBC DSN throws error "Data source name not found and no default driver specified" when creating a Multi-source enabled Data Foundation
  • User cannot combine 32-bit and 64-bit relational data providers into Multi-source enabled Data Foundation in Information Design Tool (IDT)
  • User cannot report off Microsoft Excel or Access 2010 32-bit and Oracle Database 11g 64-bit relational data providers


Read more...

Environment

  • SAP BusinessObjects BI Platform 4.0 SP05
  • SAP BusinessObjects BI Platform 4.0 SP05 Client Tools: Information Design Tool
  • Data Providers: Oracle Database 11g accessed through 64-bit Oracle client software, Microsoft Excel or Access 2010 32-bit accessed through ODBC 32-bit
  • Microsoft Windows Server 2008 R2

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3

Keywords

ODBC, Oracle, Excel, Access, Office, 2007, 2010, MSU, SSU, universe, data foundation, .blx, .dfx, data federator, 32, 64, bit, combine, IDT, 32-bit, 64-bit, no default driver specified, data source name not found, supported , KBA , BI-BIP-SL , Semantic Layer , 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.