topic Re: ODBC Connection Issue. in QlikView

ODBC Connection Issue.

prashantbaste — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have created system DSN to connect MySQL database (thru Administrative Tool) & it get "Connection Successful" message when I try thru ODBC Drivers.

But When I come into Qlikview it do not show SystemDSN to connect. And If I select User DSN that is not successful to get connect me to database.

Can anyone suggest what can be issue?

Thanks in advance ...!

Re: ODBC Connection Issue.

varshavig12 — Tue, 20 Dec 2016 10:56:00 GMT

check - Force 32 bit

Re: ODBC Connection Issue.

varshavig12 — Tue, 20 Dec 2016 10:56:42 GMT

Let me know if this works

Re: ODBC Connection Issue.

prashantbaste — Tue, 20 Dec 2016 11:02:37 GMT

Hi Varsha Vig‌,

Thank you for your valuable input.

But I tried in both ways (with Force 32 Bit & without Force 32 Bit), but it still do not show list of System-DSNs in connection box.

Re: ODBC Connection Issue.

awhitfield — Tue, 20 Dec 2016 11:03:38 GMT

Have you created 32 or 64 bit ODBC connection?

Andy

Re: ODBC Connection Issue.

ramasaisaksoft — Tue, 20 Dec 2016 11:07:36 GMT

Hi Prashant,

some times after creation of System DSN you need to restart your machine.

try it once and let me back if u still face the issue.

Re: ODBC Connection Issue.

prashantbaste — Tue, 20 Dec 2016 11:17:31 GMT

Hi Andrew Whitfield‌,

Its 32 bit connection & QV is also of 32 bit version.

Re: ODBC Connection Issue.

prashantbaste — Tue, 20 Dec 2016 11:19:05 GMT

Hi Rama Sai,

It is compulsory & necessary to restart machine?

Re: ODBC Connection Issue.

awhitfield — Tue, 20 Dec 2016 11:28:22 GMT

Just tried on my PC and the System DSN was available immediately, has you got Force 32 bit checked?

Andy

Re: ODBC Connection Issue.

awhitfield — Tue, 20 Dec 2016 11:29:44 GMT

Have you checked to see if the DSN is available in Tools ODBC Administrator in the script edit screen?

Andy

Re: ODBC Connection Issue.

prashantbaste — Tue, 20 Dec 2016 11:33:37 GMT

Yes Andrew,

I tried With & without Force 32 Bit. But its not showing any of DSN created from Administrative tools.

There is no System DSN showing in Edit Script -> ODBC Connection.

Re: ODBC Connection Issue.

Anil_Babu_Samineni — Tue, 20 Dec 2016 11:40:08 GMT

If your machine is 64-Bit. then just download and install the connector. And then use - provide a means for the Qlik Sense or QlikView to efficiently load data into an app from databases that are accessible with supported ODBC drivers. The following databases are supported with this connector package:

Apache Hive
Cloudera Impala
IBM DB2
Microsoft SQL Server
MySQL Enterprise
Oracle
PostgresSQL
Sybase ASE
Teradata

Then, Just close the Qlikview local client / Workbench and then open then connect to Connector and then use which DB you want to fetch then check.

PFA

Re: ODBC Connection Issue.

awhitfield — Tue, 20 Dec 2016 11:40:29 GMT

Have you tried using the Tools option in the edit screen? Is it listed there?

Andy

Re: ODBC Connection Issue.

jonathandienst — Tue, 20 Dec 2016 12:17:14 GMT

>>Its 32 bit connection & QV is also of 32 bit version.

I think you created a 64 bit connection. The default ODBC tools on a 64 bit machine create a 64 bit DSN which cannot be seen by 32 bit applications.

Make sure you run this version to create 32 bit connections on 64 bit Windows:

C:\Windows\SysWow64\odbcad32.exe

This version makes 64 bit connections on 64 bit (and 32 bit connections on 32 bit Windows):
C:\Windows\System32\odbcad32.exe

And those are not typos. Some MS engineer was having a really bad day when those naming conventions were developed.

Re: ODBC Connection Issue.

prashantbaste — Tue, 20 Dec 2016 13:47:06 GMT

Hi jontydkpi‌,

Thank you for valuable inputs. Those are really very helpful.

Checked with your given paths & found yes it was 64 bit. Now I have installed 32 bit connection.

Also able to get connect.

Thanks a ton

Re: ODBC Connection Issue.

prashantbaste — Tue, 20 Dec 2016 13:49:55 GMT

Hello Anil Babu,

All this is not required. I resolved my issue by re-installing 32-bit connectors.

By the way thank you for valuable inputs.

Re: ODBC Connection Issue.

prashantbaste — Tue, 20 Dec 2016 13:51:35 GMT

Andrew,

Yes from edit screen only I was trying, but not able to get System DSNs & User DSNs was not able to connect.

But now it has got resolved by re-installing 32-bit version connection.

Thank you for all your inputs.

Re: ODBC Connection Issue.

awhitfield — Tue, 20 Dec 2016 15:37:01 GMT

Glad you got it sorted!