I installed Oracle 12 on Windows 10 in all possible ways/configurations, including the defaults.
I installed Oracle Client, Instant Client, and ODAC - in all possible permutations of each of these 3.
Still no way to connect via OLE DB (from Excel, SSIS, SSRS, -..anything). No luck.
Using the correct name from TNSNames and all. or IP. same problem: when entering info to OLEDB connection prompt, getting error 'Server Name cannot be found.'.
I went through 1000 forums posts, tried 1000 things. No connection.
Apparently, there is something basic, fundamental, that I may not know or not aware of. I also reinstalled Oracle instances about 20 times. tried 12, 19, other versions... still same problem.
Is there still hope for me ?