BO Reports prompt for "Further Info" (database login, password, etc) when run from Clarity.

Article Id: 52319
Status: Published
Updated On: 14-02-2018 06:58
Legacy Id: TEC511214
Products:
CA Identity Manager , CA Identity Governance , CA Identity Portal , STARTER PACK-CLARITY PPM
Issue/Introduction:

Description:

Symptom

  • BO Reports prompt for "Further Info" (database login, password, etc) when run from Clarity.

  • Error on connection test in Universe Designer.

  • Error: "The server is not responding!
    (SBO0001) DBD: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."

Reproducing the Issue

  1. On 64-bit Windows OS, launch 64-bit ODBC Data Source Administrator.

  2. Create a System DSN by connecting with Microsoft SQL Server 2005 database.

  3. Test the connection of System DSN and make sure the connection is successful.

  4. Launch Universe Designer.

  5. Click Tools > Connections, and then click Add button to start Define a new connection wizard.

  6. Select Secured as connection type, define a connection name, and then select Microsoft > MS SQL Server 2005 > ODBC Drivers. Click Next.

  7. In Login Parameters dialog, input User name, Password and Data source name which was created at step 2.

  8. Click Test Connection button. The error addressed in the symptom displays.

    • BusinessObjects Enterprise XI 3.1

    • 64-bit Windows OS

    • 64-bit ODBC

    • Microsoft SQL Server 2005

Cause

BusinessObjects products use the 32-bit ODBC registry on all versions of Windows. 64-bit ODBC connection is not supported.

Keyword: CLARITYKB, BO, 64bit.

Solution:

Use 32-bit ODBC DSN instead of 64-bit ODBC DSN. 32-bit ODBC Data Source Administrator can be launched from"C:\Windows\SysWOW64\odbcad32.exe".

Environment:

Release:
Component: PPMENV