I have same database in oracle 11g and MSSQL 2012. I was configured requited reports in MSSQL 2012. While using same models and view with oracle connection i am getting below error.'ADsDSOObject' failed with no error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14).'. Query don't have any date field.

connection used: Provider=ADsDSOObject;Encrypt Password=False;Data Source=dbname@//10.0.125.214:1521/gissample;Mode=Read;Bind Flags=0;ADSI Flag=-2147483648

Please help me in resolving below error with oracle connection

I was used connection as oracle.
below query executed successfully in 'sqldeveloper'.
while connecting to oracle connection was successful.
I have 64 bit oracle client 12g in my machine.





5:42:16 PM Starting execution of 'Testreport'...
5:42:16 PM Executing report tasks...
5:42:16 PM Starting to build models...
5:42:16 PM Model 'Measure-ora': Building result set from database...
5:42:16 PM Model 'Measure-ora': Executing main query...
5:42:16 PM Error in model 'Measure-ora': Unexpected error when executing the following SQL statement:

SELECT
TABLE1.FEATURECLASS AS C0,
TABLE2.ENTRYDATE AS C1,
TABLE1.FEATURECLASS AS C2,
TABLE1.FIELDNAME AS C3,
Avg(INPUTVALUES.TABLEMAINVALUE) AS C4
FROM
(TABLE2 INNER JOIN
(TABLE1 INNER JOIN
(INPUTVALUES LEFT OUTER JOIN TABLEMAIN
ON TABLEMAIN.TABLEMAINID=INPUTVALUES.TABLEMAINID)
ON TABLE1.FIELD1ID = INPUTVALUES.FIELD1ID)
ON TABLE2.ENTRYDATEID = INPUTVALUES.ENTRYDATEID)
WHERE TABLEMAIN.TABLEMAINID IN (12)
GROUP BY TABLE1.FEATURECLASS,TABLE2.ENTRYDATE,TABLE1.FIELDNAME
ORDER BY TABLE1.FEATURECLASS ASC,TABLE1.FIELDNAME ASC,TABLE2.ENTRYDATE ASC,Avg(INPUTVALUES.TABLEMAINVALUE) ASC


Error detail:
'ADsDSOObject' failed with no error message available, result code: DB_E_ERRORSINCOMMAND(0x80040E14).
5:42:16 PM Rendering report...

Edited by user Tuesday, November 10, 2015 12:22:36 PM(UTC)  | Reason: Not specified