topic OLEDB read failed in QlikView

OLEDB read failed

Fri, 03 May 2013 10:40:17 GMT

After an OLEDB CONNECT TO claue I am trying to use the following SQL statement in my QlikView Script:

SQL SELECT * FROM [JBVProcessDB01].[dbo].[tblEvent01]

INNER JOIN

(

SELECT MAX(DateTime) as LatestDate, [sFieldValue0]

FROM [JBVProcessDB01].[dbo].[tblEvent01]

Group by sFieldValue0

) SubMax

on [JBVProcessDB01].[dbo].[tblEvent01].DateTime = SubMax.LatestDate

and [JBVProcessDB01].[dbo].[tblEvent01].sFieldValue0 = SubMax.sFieldValue0 and lFieldValue2 > 2

But when I run the script I get an error message stating that "OLEDB read failed". This SQL query works fine in SQL management studio, and I have tested my OLEDB CONNECT TO statement which also works.

So what can be the problem here?

Re: OLEDB read failed

Mon, 28 Oct 2013 12:27:45 GMT

though too late, but just wanted to answer for others so that they do not find it unanswered

I had the same "OLEDB read failed" error. Which occurred due to duplicate columns names in the query. When removed, it worked.

Re: OLEDB read failed

Mon, 12 May 2014 19:37:10 GMT

Nice work Sibtain Naqvi!

Thank you so much!