CS: COM Provider CLSID not specified or erroneous

building semantic layer
1

this is the error i see when i try to connect a universe. i mean test a universe connection.
CS: COM Provider CLSID not specified or erroneous
can anyone please specify what does this mean and how to rectify this error.

thankz in advance.
dilip 8)

dilip.varala (BOB member since 2010-03-16)

2

Welcome to B :mrgreen: B

This is a SQL Server error. Are you using the correct driver version when you created your connection? Have you installed the client on your server at all that would allow you to verify you have connectivity to the database?

V

Eric Vallo :us: (BOB member since 2002-08-15)

3

[Moderator Note: Moving from Web Intelligence to Semantic Layer - MichaelWelter]

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

4

Check this thread: https://forums.sdn.sap.com/thread.jspa?threadID=1004813&tstart=0

and then this thread: https://forums.sdn.sap.com/thread.jspa?threadID=1294539&tstart=0

I’ve run into this before, solving it with the first link …

Hope this helps

Atul Chowdhury (BOB member since 2003-07-07)

5

I ran into the same error, using SQL Server 2008. I’m most familiar with oracle so not so sure how SQL server drivers work. Weird thing is I can create the universe connection in R2 but in 3.1 I get the same error.

The SAP note says to either install the SQL Native Client driver or modify the parameters in the oledb.sbo file.

Is that what you did to get this working? Where an I download the SQL Native Client driver.

Edit: I fixed the issue by downloading the native driver. I got it from the microsoft website after a google search.

bension (BOB member since 2005-09-01)

6

The below procedure worked for me :+1: , try out if it does for you
:?:
Open the oledb.sbo file located in the oledb directory under the connectionServer install directory.
Location : / wind32_x86/dataAccess/ConnectionServer/oldedb
Under the section of the file, change the following two parameters:
Parameter Provider CLSID " change value to: SQLOLEDB
Parameter Enumerator CLSID " change value to: SQLOLEDB Enumerator

In the oledb.sbo file, locate the section. The parameters you set in the the section should be the same as the corresponding values in section.

BOBJ_Novoice :india: (BOB member since 2010-04-14)

7

The exact same error popped up with me at a BO4 Sp2 install.
Downloaded the MS SQL Server 2008 Native client SQLNCLI.msi from the microsoft site and installed it at the BO server, and everything was fine…

Tiny :netherlands: (BOB member since 2004-11-10)