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.