topic Re: ODBC read failed in QlikView

ODBC read failed

Wed, 07 May 2014 06:47:56 GMT

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.

Re: ODBC read failed

SunilChauhan — Wed, 07 May 2014 07:07:33 GMT

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

kaushiknsolanki — Wed, 07 May 2014 07:19:19 GMT

Hi,

Also check the connection string and the availability of database.

Regards,

Kaushik Solanki

Re: ODBC read failed

Wed, 07 May 2014 07:43:24 GMT

Thx for the reply.

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

Re: ODBC read failed

Wed, 07 May 2014 07:45:12 GMT

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.

Re: ODBC read failed

Wed, 07 May 2014 07:46:54 GMT

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

Re: ODBC read failed

kaushiknsolanki — Wed, 07 May 2014 07:58:48 GMT

Hi,

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

Regards,

Kaushik Solanki

Re: ODBC read failed

SunilChauhan — Wed, 07 May 2014 08:15:20 GMT

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

hope this helps

Re: ODBC read failed

sudeepkm — Wed, 07 May 2014 08:21:24 GMT

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

its_anandrjs — Wed, 07 May 2014 13:18:51 GMT

Try to write errormode before the load statement

Set ErrorMode=0;

Load * From Location;

Re: ODBC read failed

nagaiank — Wed, 07 May 2014 13:51:21 GMT

I also had a similar problem. This started happening when I downgraded to QV11 SR5 from QV11 SR6 (I do not know if this had any influence in causing the error.)

The error does not appear if I run QV.exe as administartor (by selecting 'Run as Administrator'). I do have administrator privleges to my laptop. When I start QV.exe, the ODBC error results. But when I start QV.exe as administrator, script execution shows no ODBC error.

Re: ODBC read failed

Tue, 06 Jan 2015 07:32:13 GMT

Hi Wilson,

Even I have the same Problem , Even though the file was fetching the Data perfectly from the DB now suddenly it shows the ODBC Read Failed .What am planning to do is to split each table into separate qvw file and link it in a loop with QMC based on the Successful Reload of another task . Even if this error repeats we could re start the task from were the task has failed.

Hope This might help us.....

Thanks