Question to ODBC connection problems in Qlikview designer

[#1]

Question to ODBC connection problems in Qlikview designer

Hi all Qlikview experts.

We have just installed Qlikview on a new development Qlikview server.

In Qlikview designer tool, no ODBC connections are available when you open the edit script to enter an ODBC connection to an Oracle database.

The required connections data are entered in MS ODBC and Oracle client forms, and testing connections works fine from both. Please see attached file for more details.

Has anyone any idea how to solve this problem?

Thanks and regards

Gunnar B Melby

Energiselskapet Buskerud

Drammen, Norway

[Andrea_Ghirardello]

Your ODBC was probably created using 32bit version of odbcad32.exe.

In the QlikView script editor try to connect using the "Force 32 Bit" flag.

If you want to check manually the existing system/user odbc sources in your system, run both

C:\Windows\SysWOW64\odbcad32.exe and C:\Windows\System32\odbcad32.exe.

[fernando_tonial]

See the image.

[Andrea_Ghirardello]

Is the EBLIS system DSN a 64 DSN or a 32 DSN?

[#5]

Thanks for helping solving this problem.

The reason for this problem was related to 32 bit/64 bits problem.

The new server is running on 64 bit OS. A 64 bits version Oracle 11G client was installed.

ODBC connections did not work in Qlikview designer work since 32 bits version of the designer software was installed, and the communication with the Oracle client was not possible.

Reinstalling a Qlikview designer 64 bits version, then enter ODBC connections in C:\Windows\System32\odbcad32.exe (to database EBLIS as system DSN) solved the problem.

Thanks and regards

Gunnar