Windows 2016, SQL 2016 and VSDT 2017 v15.9.39. Using Provider=OraOLEDB.Oracle, got Source: "OraOLEDB" Hresult: 0x80040E14 Description: "ORA-00936: missing expression". Should I use different provider? Thanks.
Firstly take the query and run it on the Oracle server to make sure the query you are running is correct.
Missing expression is generally the query is goosed somewhere and not a provider issue.
I was able to execute query in SQLDeveloper without any issue. Ran into error displaying preview like many people experienced -- system cannot find msg text for 0x80040e51 for OraOLEDB.
17 People are following this question.