Qlik Sense ODBC connection gets error but tests fi... - Qlik Community

TF · ‎2018-12-26

I have an ODBC connection set up that is 32bit and it tests fine and I can also use it to connect with MS Access to the tables and it opens and pulls data fine, but when I go to use it in Desktop Qlik Sense I get an error Connector Connect Error, access denied.

This is connecting to a Progress open edge Database.

Any help would be appreciated, I spent a lot of time on google and on here with no luck.

kaushiknsolanki · ‎2018-12-27

Hi,

Try creating the User DSN.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anil_Babu_Samineni · ‎2018-12-27

Can't you use directly using "Postgre SQL" as data source?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

TF · ‎2018-12-27

I did that and it does the exact same thing, it connects fine when I create the odbc but not in Qlik.

It also works fine with access and excel to pull data.

TF · ‎2018-12-27

I don't know how to do that,, what does that mean,, I have an odbc connection set up and that is how I am use to connecting to the data. Can you give me some help on how to try that.

Thanks

Qlik Sense ODBC connection gets error but tests fine with excel or access

ODBC Progress Connection