topic Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered in QlikView

ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

Thu, 02 Jan 2014 07:35:41 GMT

Hi all,

Im getting this error while connecting to Oracle database:

ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle;Persist Security Info=False;User ID=xxx;Data Source=localhost;Extended Properties=""] (XPassword is xxx)

Oracle server is running and I can connect to it via ORacle SQL Developer...
Can you give me a hand, please?
Im new to qlik

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

joshabbott — Thu, 31 Jul 2014 13:07:12 GMT

Didn't want to start a new thread. I'm having this exact same problem, does anyone have any idea's? This works fine on a co-workers machine, but not mine. I'm not exactly sure where to look. Thank you for any help!

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

Thu, 21 Aug 2014 19:52:09 GMT

Hi Josh!

You have helped me with all of my questions thus so far.. maybe it's time I can help you! Have you checked to make sure you had the database added in administrative tools?

click Start -> Control Panel
In Control Panel, double click “Administrative Tools” icon.
Then double click “Data Sources(ODBC)” and click “System DSN” tab.
It will show “Create New Data Source” window.
Choose the Oracle Database and click Finish.
Provide the Data Source Name and Service Name, Schema Name and Password.
Click Ok to add the data source.

I don't know if that will do it but it's worth a shot... Thanks for all the help you've given me in the past!

Joe

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

Anonymous — Tue, 11 Nov 2014 13:02:28 GMT

I am getting the same error.I checked Data Sources(ODBC),everything is fine and the connection is successful over there.I searched in google but din't find a solution for this..Can anyone please say me whats wrong ...and what can be done to resolve the error..

Thanks in Advance...

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

Tue, 11 Nov 2014 13:40:30 GMT

Hi,

Can you try to connect to the DB using ODBC.create the connections at control panel-> administrative tools->odbc create cnnection der and re use it using qlikview

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

agomes1971 — Tue, 11 Nov 2014 13:49:35 GMT

Hi,

please check if the provider is correct.

Hope it helps

André Gomes

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

Anonymous — Tue, 11 Nov 2014 15:52:08 GMT

@rakesh goud I created the connection in control panel ->administrative tools ->odbc and gave the db details in a file and tried calling it using script in qvw..but still i am getting the same error....

Andre Gomes I checked, the provider is correct..the same details are working fine in my friends system..unable to understand whats the problem with mine..

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

agomes1971 — Tue, 11 Nov 2014 16:01:58 GMT

Hi,

When you are doing the data manipulation and moving around field names, sometimes you leave the original field among the others and create a duplicated one. You may get this error message.

Kind regards

André Gomes

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

agomes1971 — Tue, 11 Nov 2014 16:44:15 GMT

Hi,

have you reached any conclusion?

Thanks

André Gomes

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

Anonymous — Tue, 11 Nov 2014 17:01:39 GMT

Hi,

Andre Gomes

No, not yet..still trying..

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

agomes1971 — Tue, 11 Nov 2014 17:38:54 GMT

Hi,

I think you're working on a mix mode environment. What is your OS (32 or 64 bit)?

And your oledb or odbc drivers?

Make this analysis...

Regards

André Gomes

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

Anonymous — Wed, 12 Nov 2014 06:23:49 GMT

Hi,

yes the problem was with mix mode environment.

I changed the connect statement in my script from connect to connect32 and it worked.

Thanks for your suggestions.

Regards,

Manasa

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

agomes1971 — Wed, 12 Nov 2014 09:52:20 GMT

Hi,

so you can put may answer as correct, right?

Thanks

André Gomes

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

Anonymous — Wed, 12 Nov 2014 10:20:16 GMT

Hi,

I could not find the option to mark it as correct..Can you say me where can i find it...

Regards,

Manasa

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

agomes1971 — Wed, 12 Nov 2014 11:16:36 GMT

Hi,

greengold

can you put some answer as the correct one please?

Thanks

André Gomes

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

agomes1971 — Wed, 12 Nov 2014 12:08:18 GMT

Hi,

you can not find because you´re not the owner of the post.

But I appreciate the honor that you gave me manasamale.

Thanks

André Gomes

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

rsdhavle — Thu, 20 Nov 2014 08:11:47 GMT

Even I am getting the same error and it seems there is no proper solution for this.

Was anybody able to resolve this problem?

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

Anonymous — Thu, 20 Nov 2014 16:48:05 GMT

For me it got resolved after replacing connect with connect32 in my script to connect to a database because the problem was with 32 and 64 bit environments..

Re: ErrorSource: Microsoft OLE DB Service Components, ErrorMsg: Class not registered

rsdhavle — Thu, 22 Jan 2015 15:10:51 GMT

I tried doing that as well by stating connect32 still i keep on getting same error. Any other work around?