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.