topic Re: Error when loading data from Access db files in QlikView

Error when loading data from Access db files

apoorvasd — Tue, 23 Apr 2019 09:10:57 GMT

Hello Everyone,

I get the following error when tried to pull data from access db files. All these days it was working fine, but from past 3 days, the report is failing due to this error. I tried to recreate the connection, even that didn't help me. Any help in fixing this error?

Thank you.

Re: Error when loading data from Access db files

Anil_Babu_Samineni — Tue, 23 Apr 2019 12:01:02 GMT

For me this sounds as "MS Access" got upgraded. The latest version of MS access should enable "SSL package with trusted". Please plugin that and re-create using the same settings.

Re: Error when loading data from Access db files

apoorvasd — Tue, 23 Apr 2019 12:14:40 GMT

Hi,

Thanks for the response!

But could you please tell me where I can enable this option?

Re: Error when loading data from Access db files

Anil_Babu_Samineni — Tue, 23 Apr 2019 12:28:18 GMT

Please talk to Certificate team. They will configure for you as you are the developer, You won't have permission.

Re: Error when loading data from Access db files

Brett_Bleess — Tue, 18 Jun 2019 15:23:18 GMT

Just a quick side note as well, I generally do a Google or other search on these messages, and most of the time they are going to be Connector related when there is a SqlState message and subsequent error message, we are just returning in our logs what the Connector has passed back to us, so be sure to do that search as generally that should help point in the right direction as well.

I believe the other poster is likely on the right track as well from the message, but I just wanted to add some additional info on how to try to get some further information for anyone checking this in the future. Oh, if the other poster's comment ends up helping you resolve things, do not forget to come back and mark things as the solution, so others have that confirmation.

Regards,
Brett