Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

ODBC read failed

Hi,

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.

Regards,

Wilson.

Tags (3)
11 Replies
chauhans85
Esteemed Contributor

Re: ODBC read failed


check for duplicate fieldName in a table

if found load it only once

this was my case and resolved my issue.

hope this helps

Re: ODBC read failed

Hi,

     Also check the connection string and the availability of database.

Regards,

Kaushik Solanki    

Not applicable

Re: ODBC read failed

Thx for the reply.

Unfortunately, there's no duplicate fieldName in my table. I've checked that.

Not applicable

Re: ODBC read failed

Hi, Kaushik

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.

Not applicable

Re: ODBC read failed

Does it load any data at all, or does it fail before starting to load data?

Re: ODBC read failed

Hi,

     Just make sure that your RAM reaches to the 100% or not, if yes then you might need additional RAM.

Regards,

Kaushik Solanki

chauhans85
Esteemed Contributor

Re: ODBC read failed

have you selected database name while creating conncetion string.

if not please select.

or

there are few functions also which creates this errors.try to found equivalent concept for those function inqlikview

hope this helps

sudeepkm
Valued Contributor III

Re: ODBC read failed

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.

Re: ODBC read failed

Try to write errormode before the load statement

Set ErrorMode=0;

Load * From Location;

Community Browser