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 fails

Hi,

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.

Thanks,

Sudha

7 Replies
sinanozdemir
Valued Contributor III

Re: ODBC Read fails

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.

Re: ODBC Read fails

Hi,

Have you tried with OLEDB instead of ODBC?

check the below link, may be helps..

ODBC Read Failed Part II

MVP
MVP

Re: ODBC Read fails

Hi,

Did you tested ODBC in ODBC Administrator by Clicking Test Connection?  If it is working there then it should work in Qlikview also.

Regards,

Jagan.

rank_nandha
Contributor II

Re: ODBC Read fails

Hi,

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.

Regards,

Nandha

vardhancse
Valued Contributor II

Re: ODBC Read fails

If we are trying to run the task from QMC, we need to give permission to QlikView service accounts in the oracle tables/views.

Until and unless we give access to service accounts, we cannot load the data from QMC

Not applicable

Re: ODBC Read fails

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.

effinty2112
Honored Contributor

Re: ODBC Read fails

Hi Sudha,

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.

Cheers

Community Browser