The big source query executes fine in Oracle but qlikview says 'ODBC read failed' How can I fix this? Please let me know if you need more information on this.
Check your ODBC settings to make sure that you are pointing to the correct server & database, and also login credentials such as Windows authentication or other user id and password settings.
Are you using ' * ' in your query? Insted of * using the Table name and try. Before doing this as Jagan said test your ODBC admin by clicking Test Connection.
Slightly old question, but I found this thread on Google. I just had this error as well and found it was because I was trying to manipulate the data as I was loading it from SQL.
I got around this by simply loading everything from the SQL database into a temporary resident table, then loaded from the resident table and did my manipulations then.
If you're doing this already forgive me but can I suggest using a preceding load. Keep the bottom script loading from your source absolutely simple with no renaming of fields or any manipulation at all.
.png "Luminary Alumni"){kind=icon}
