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 ...!
Solved! Go to Solution.
>>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.
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.