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

SAP Knowledge Base Article - Public

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

Symptom

Creating multiple OLEDB connections to different databases residing on the same server

Environment

Product Version:Business objects Enterprsie XIR2, Service pack 5 

Database version: MS SQL Server 2005

Reproducing the Issue

  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

Cause

This is by design we cannot create multiple OLEDB connections to databases residing on the same server

Resolution

Use an alternative middleware (ODBC or native drivers) to the second connection

Keywords

KBA , BI-BIP-SL , Semantic Layer , How To

Product

SAP Crystal Reports XI