Skip to main content
Announcements
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
cancel
Showing results for 
Search instead for 
Did you mean: 
prashantbaste
Partner - Creator II
Partner - Creator II

ODBC Connection Issue.

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 ...!

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

>>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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

17 Replies
varshavig12
Specialist
Specialist

check - Force 32 bit

varshavig12
Specialist
Specialist

Let me know if this works

prashantbaste
Partner - Creator II
Partner - Creator II
Author

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.

awhitfield
Partner - Champion
Partner - Champion

Have you created 32 or 64 bit ODBC connection?

Andy

ramasaisaksoft

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.

prashantbaste
Partner - Creator II
Partner - Creator II
Author

Hi Andrew Whitfield‌,

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

prashantbaste
Partner - Creator II
Partner - Creator II
Author

Hi Rama Sai,

It is compulsory & necessary to restart machine?

awhitfield
Partner - Champion
Partner - Champion

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

Andy

awhitfield
Partner - Champion
Partner - Champion

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

Andy