question

Chris 2 avatar image
Chris 2 asked

VSDT 2017 v15.9 connect to Oracle

Hi,

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.

ssis errorsql-server-2016
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
anthony.green avatar image
anthony.green answered

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Chris 2 avatar image
Chris 2 answered

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.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·
Do you have “allow in process” set at the driver level and rpc / rpc out enabled at the linked server level?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.