ODBC connector doesn't work - Qlik Sense Desktop

[Thiago_Justen_]

Hello guys,

I'm facing an error (as follow) with the ODBC connector after upgrade to 2018 June version.

Connections were working till this upgrade...

Is anybody facing with something like this? What should I do?

Cheers

mto‌, ltu‌, cuv‌

Editted by: thiago.justen‌

[Gysbert_Wassenaar]

You defined the ODBC connection in the 32-bit ODBC Administrator tool.Then you try to find it in Qlik Sense in the list of 64-bit ODBC connections. Either define the ODBC connection in the 64-bit ODBC Administrator tool or in Qlik Sense look in the list of 32-bit ODBC connections.

[Thiago_Justen_]

Actually I gave you a bad screenshot. I would attach one wich has the 32-bit list empty too.

As I said before: everything was working fine till 2018 June version.

[balabhaskarqlik]

May be can remove the DSNs and recreate those, now try to create OLEDB connections from initial.

June version not, supporting some extensions too. Updated the extensions and cleared the cache, then working.

[Thiago_Justen_]

Thanks for your reply Bala. I've already made all of these but the result still the same. This situation is freaking me out...

[Thiago_Justen_ · Accepted solution]

Folks,

Issue solved! I did this simple step and then, now, it works just fine.

Download and install Visual Studio 2005 redistributable.

Hope it helps anyone who is facing the same issue.

Cheers

[Clever_Anjos]

If you´re connecting to Redshift why don´t use the embbed connector?

[Thiago_Justen_]

Clever,

Actually I was using an ODBC connection to my Oracle database....even the embbed oracle connector didn't work.

Cheers

[Clever_Anjos]

It´s supposed to work in both situations.

Please contact me in private, let´s check it together

[Thiago_Justen_]

Could we talk on Skype?

Skype: justen.thiago