I am trying to refresh certain qlikview files. When I reload it on my local machine, I able to access the database through the ODBC connection but when I place the file on server and try to refresh it automatically, it gives me the following error.
The Source Document was NOT reloaded successfully. DocumentPath=C:\Program Files (x86)\QlikView\Examples\Analysis.qvw. Errors: 4 ScriptError: General ODBC Error, ScriptErrorList: General ODBC Error General ODBC Error General ODBC Error General ODBC Error
I am not able to identify the error. Any inputs would be really helpful.
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.