1546459 - Creating multiple oledb connections to different databases residing on the same server

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

1. Define an OLEDB connection to a database on a server.
2. Create another OLEDB connection to another database residing on the same server.
3. 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