DEVELOPERS COMPLAIN THAT THEY ARE RECEIVING ERRORS WHEN TRYING TO...

11. Developers complain that they are receiving errors when trying to perform

ad hoc distributed queries against Oracle, although they are able to run

distributed ad hoc queries against SQL Server. What must you do to solve the

problem?

A. Install the Oracle client libraries on the developer workstations.

B. Use sp_configure to set the “Ad Hoc Distributed Queries” to 1

C. Enable the “disallow adhoc access” property on the Oracle OLE DB

provider

D. Disable the “disallow adhoc access” property on the Oracle OLE DB