Creating multiple OLEDB connections to different databases residing on the same server
Product Version:Business objects Enterprsie XIR2, Service pack 5
Database version: MS SQL Server 2005
Reproducing the Issue
- Define an OLEDB connection to a database on a server.
- Create another OLEDB connection to another database residing on the same server.
- We will not be able to see both the connections in the manage objects options in the CMC
This is by design we cannot create multiple OLEDB connections to databases residing on the same server
Use an alternative middleware (ODBC or native drivers) to the second connection
KBA , BI-BIP-SL , Semantic Layer , How To