OD-CON-0001 Failed to connect to OLE DB for the provider

by ·0 Comments

Product:

Cognos BI 10.1.1

Windows 2008 R2 server

MSAS SSAS 2008

Symptom:

You have created a data source to a SSAS 2008 cube, and test it in Cognos connection.

It works for CQM but you get a error for DQM.

Error message:

http://servername:9300/p2pd  Microsoft Analysis Services 2008 / Compatible  Succeeded

http://servername:9300/p2pd  Microsoft Analysis Services 2008 / Dynamic  XOD-CON-0001 Failed to connect to OLE DB for the provider (Microsoft Analysis Services 2008) and server (sr01868): ERROR [category=ASSERTION,statusCode=0,causeCode=0,source=CODBOConnection::UpdateConnectionProperties(CNativeEnv&) at Java_com_cognos_xqe_data_providers_olap_odbo_ODBOConnection_cUpdateConnectionProperties]: CCLAssertError: CCL_ASSERT(NULL != m_pIDBInitialize);

Cause:

The DQM report service is 64 bit JAVA program and need the 64 bit version of the driver to be installed on the Cognos BI server.

In control panels add/remove programs the driver is listed as

111 MB version 10.50.1600.1    (the working version)

or

77,5 MB version 10.52.4000.0   (not working version)

 

Possible Solution:

Download the x64 version of Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2 from site http://www.microsoft.com/en-us/download/details.aspx?id=16978

File size is 55526 KB for SQLSERVER2008_ASOLEDB10.msi file 64 bit version.

Install the driver on the Cognos BI server and test the connection again.

Connection string:

;LOCAL;M8;SERVER=sr01868;Trusted_Connection=yes;LCID=en