This content has been marked as final. Show 2 replies
You actually installed the client *3* times there.
I'm fairly sure install Instant client via win32_11gR2_client will not give you oraoledb. ODAC and administrator/runtime will though.
You should only need install ODTwithODAC112021 OR win32_11gR2_client (with runtime or administrator option) and be able to connect using SQLServer.
This is great, worked perfectly. After reinstalling the administrator client tools it worked. Thanks so much for this suggestion. Have been working on this for hours.