Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
thiago_justen
Valued Contributor III

ODBC connector doesn't work - Qlik Sense Desktop

Hello guys,

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

Capturar.PNG

Connections were working till this upgrade...

Capturar.PNG

Capturar.PNG

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

Cheers

mto‌, ltu‌, cuv

Editted by: thiago.justen

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
1 Solution

Accepted Solutions
thiago_justen
Valued Contributor III

Re: ODBC connector doesn't work - Qlik Sense Desktop

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

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
10 Replies
MVP & Luminary
MVP & Luminary

Re: ODBC connector doesn't work - Qlik Sense Desktop

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.


talk is cheap, supply exceeds demand
thiago_justen
Valued Contributor III

Re: ODBC connector doesn't work - Qlik Sense Desktop

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.

Vincular Agendamento a Romaneio.gif

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
balabhaskarqlik
Honored Contributor

Re: ODBC connector doesn't work - Qlik Sense Desktop

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
Valued Contributor III

Re: ODBC connector doesn't work - Qlik Sense Desktop

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 Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
thiago_justen
Valued Contributor III

Re: ODBC connector doesn't work - Qlik Sense Desktop

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

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Employee
Employee

Re: ODBC connector doesn't work - Qlik Sense Desktop

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

thiago_justen
Valued Contributor III

Re: ODBC connector doesn't work - Qlik Sense Desktop

Clever,

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

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Employee
Employee

Re: ODBC connector doesn't work - Qlik Sense Desktop

It´s supposed to work in both situations.

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

thiago_justen
Valued Contributor III

Re: ODBC connector doesn't work - Qlik Sense Desktop

Could we talk on Skype?

Skype: justen.thiago

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago