Eric M Russell (5/20/2015)
Mr Corn Man (5/20/2015)
...In addition to this query, part of the solution required me to add a registry DWORD value for the OraOLEDB.Oracle provider. That registry value was DisallowAdHocAccess with a value of '0'.
...
You had to make this registry entry on the Windows server box? How so without being an Admin ?
Hi,
to be honest this answer and solution is more complicated than the normal solution of creating a TNS_ADMIN System variable and installing the instant Client.
All that needs to be done in addition to that is to create a linked Server in SQL Server and run the query with OPENQUERY.
Regards,
Kev