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.
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:
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.
>>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:
This version makes 64 bit connections on 64 bit (and 32 bit connections on 32 bit Windows):
And those are not typos. Some MS engineer was having a really bad day when those naming conventions were developed.
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
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.