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

[#1]

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

[agomes1971]

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

[Anonymous]

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

[agomes1971]

Hi,

so you can put may answer as correct, right?

Thanks

André Gomes

[Anonymous]

Hi,

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

Regards,

Manasa

[agomes1971]

Hi,

greengold

can you put some answer as the correct one please?

Thanks

André Gomes

[agomes1971]

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

[rsdhavle]

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

Was anybody able to resolve this problem?

[Anonymous]

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..

[rsdhavle]

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