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
- On 64-bit Windows OS, launch 64-bit ODBC Data Source Administrator.
- Create a System DSN by connecting with Microsoft SQL Server 2005 database.
- Test the connection of System DSN and make sure the connection is successful.
- Launch Universe Designer.
- Click Tools > Connections, and then click Add button to start Define a new connection wizard.
- Select Secured as connection type, define a connection name, and then select Microsoft > MS SQL Server 2005 > ODBC Drivers. Click Next.
- In Login Parameters dialog, input User name, Password and Data source name which was created at step 2.
- 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".