TechTip: How to Resolve "CS:COM Provider CLSID not specified or erroneous"

Document created by A_H Employee on Mar 17, 2016
Version 1Show Document
  • View in full screen mode

Error

When trying to edit the universe in the Universe Designer, you may result into the below error

"CS:COM Provider CLSID not specified or erroneous" trying to create SQL Server 2005 OLEDB connection in Designer

 

Symptom
When trying to create SQL Server 2005 OLEDB connection in the Designer, an error message appears:

"CS:COM Provider CLSID not specified or erroneous".

 

Cause
The issue has been identified and tracked under ID ADAPT00736944.

 

Solution

Modify parameters in the oledb.sbo file.

Steps to Modify oledb.sbo file:

Step 1)   Open oledb.sbo file

( Located in the oledb directory under the connectionServer install directory C:\ProgramFiles\CA\SC\CommonReporting3\BusinessObjectsEnterprise12.0\win32_x86\dataAccess\connectionServer\oledb\oledb.sbo )

Step 2) If your are trying to connect to MSSQL SERVER 2008 , then

Under the <DataBase Active="Yes" Name="MS SQL Server 2008"> section of the file, change the following two parameters:
Parameter Provider CLSID " change value to: SQLOLEDB
Parameter Enumerator CLSID " change value to: SQLOLEDB Enumerator

Example of a modified file:

<DataBase Active="Yes" Name="MS SQL Server 2008">

<Library>dbd_wsqloledb</Library>

            <Parameter Name="Family">Microsoft</Parameter>

            <Parameter Name="Version">mssqlserver_oledb.setup</Parameter>

            <Parameter Name="Driver Capabilities">Query,Procedures</Parameter>

            <Parameter Name="SQL External File">sqlsrv</Parameter>

            <Parameter Name="SQL Parameter File">sqlsrv</Parameter>

<Parameter Name="Description File">sqloledb</Parameter>

            <Parameter Name="Provider CLSID">SQLOLEDB</Parameter>

            <Parameter Name="Enumerator CLSID">SQLOLEDB Enumerator</Parameter>

            <Parameter Name="Extensions">sqlsrv2008,sqlsrv,oledb</Parameter>

            <Parameter Name="SSO Available" Platform="MSWindows">True</Parameter>

        </DataBase>

In the oledb.sbo file, locate the <DataBase Active="Yes" Name="MS SQL Server 2000"> section. The parameters you set in the the <DataBase Active="Yes" Name="MS SQL Server 2005"> section should be the same as the corresponding values in <DataBase Active="Yes" Name="MS SQL Server 2000"> section.

Attachments

    Outcomes