Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Activex component can't create object:'ADODB' connection

Hi

Am using QV10 desktop and while trying to run a macro, am stuck up at this error: Activex component can't create object: 'ADODB connection'

The same code when run in my colleague's PC, its working fine.

We are new to Qlikview and could'nt figure out why this is happenning. Any DB connection Settings needs to be changed?

Can anyone help with this?

Am using QV10 and my colleague is using QV9.

Thanks,

Priya

2 Replies
danielrozental
Honored Contributor II

Activex component can't create object:'ADODB' connection

You need to give the macro access to the system. Try ctrl+shift+m with the application open to change security settings.

Not applicable

Activex component can't create object:'ADODB' connection

Hi

Thanks a lot for your replySmiley Happy Sorry for the late reply, System access is already given to the macros.

I have searched a lot and got some information

The problem is something regarding a .dll file not being registered with the system registry.

When this issue is looked into, I have successfully registered the .dll file and now the error am getting is different. It says "Provider cannot be found. It may not be properly installed. " 

It is a clear message that DB provider is not properly installed. But I can reload the QV file connecting to the same DB and in this case the connection to the DB is working fine and now I really couldn't figure out what the problem is

Can anyone look into this please..

Thanks,

Priya

Community Browser