Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

New Contributor III

Connect with a 32bits client to a database on a 64 bits server

Lately we had an issue with the connection to an Oracle 8 database. For that old database version there is only a possibillity to connect with a 32bits client.

This is possible in QlikView by forcing 32bits. So far so good. We are also working with a Progess database and also that version (I don't know which version) can only work with a 32bits client.

And ofcourse where Progress 32bits client works fine, Oracle was facing a lot of issues. In ODBC connection works ok, in QlikView it doesn't. We read a lot of pages on the Internet and understand that there was something with the path "c:\Program Files (x86)". It's not a QlikView or Oracle issue even Microsoft software like Access and Excel are facing the same issue.

QlikView just do what Microsoft requires, they put their 32bits software in the  "c:\Program Files (x86)" directory and  their 64bits in  "c:\Program Files".

My collegue said  "Why don't we go crazy, and put  "c:\Program Files (x86)\QlikView\qvconnect32.exe" into c:\Program Files\QlikView\ .

Now you are wondering if that is working. I can tell you, it works and even the Progress client remains to funtion as well.

Maybe it's a good idea for QlikView not to listen to the requirements of Microsoft and just put the qvconnet32.exe in the same directory as the qvconnect64.exe.

Community Browser