Demystifying SQL-Oracle Distributed Query Issues

While running the following query distributed query select * from openrowset (‘OraOLEDB.Oracle’,’oradb’;’scott’;’pwd1234$’, ‘select * from emp’) I got the following error message : Msg 15281, Level 16, State 1, Line 1SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this component is turned off as part of the security configuration…

2