Which version of QlikView are you using?
I imagine that the server is 64-bits so if you are using the version 9 and you have QV 32-bit installed in the server, make sure to use the 32-bit ODBC to connect to the database or if you have QV 64-bit installed in the server then make sure to use the 64-bit ODBC.
If you are using QV version 10 then in the script menu select the correct option connect to a 64-bit or 32-bit ODBC.
I am using the Qlikview Version 9 but the Qlikview server is version 8.
I am not able to locate the 32 bit or 64 bit ODBC connection options on the connection screen.
Can you tell me how to identify whether my version and the qlikview server version have 32 or 64 bits?
Thank you very much for the help.
odbc connection options.JPG 43.3 K
In the server, close all the windows ODBC windows to avoid confusion which is 64-bits and which is 32-bits.
Run "c:\windows\syswow64\odbcad32.exe" to see the list of 32-bit ODBC's that are installed in the server. Is the ODBC you want to connect to there?
Since you are reloading with the 32-bit QV on the server your ODBC has to be created there.