Discussion Board for collaboration on QlikView Scripting.
I'm having some trouble loading my data into QlikView through ODBC driver / OLEB driver.
Qlikview always toss me an ODBC read failed SQL SELECT bla bla bla FROM `filename`, whenever I reload the data.
Funny thing is, I've the same set of data that has not been modified since day 1 at home and It could load perfectly fine with the exact same script (I copied and paste).
Any experts out there who might have a solution to this? Any help is welcome.
check for duplicate fieldName in a table
if found load it only once
this was my case and resolved my issue.
hope this helps
Also check the connection string and the availability of database.
Thx for the reply.
Unfortunately, there's no duplicate fieldName in my table. I've checked that.
My connection string is correct. The error only pop up after it connected. As I said, I've the exact same script at home and it works fine at home. As for the file size its only 300+MB within the limitation of 2GB.
Does it load any data at all, or does it fail before starting to load data?
Just make sure that your RAM reaches to the 100% or not, if yes then you might need additional RAM.
have you selected database name while creating conncetion string.
if not please select.
there are few functions also which creates this errors.try to found equivalent concept for those function inqlikview
Do you have force 32 bit on or off?
Are there any other db load script present in the same script?
Try connecting to the database using SQL+ or other DB interface tool and check if it is working.
If it is Access DB then check if it is currently opened or accessed and locked by another script or program.
Try to write errormode before the load statement
Load * From Location;