My error is the same as the original question. I don't know why that version doesn't work, but when I tried the other version it worked right away.
You mean the path issue?
yes, and now that I have it working with a different version. I have no interest to keep trying one that doesn't work for me. Which is why I marked this question as answered.
thanks for your help Senthil
Your answer may mislead others who search for such issue and may conclude Oracle ODBC driver 22.214.171.124 won't work on Windows Server 2012 R2 which is not correct.
perhaps, but if they go through the same issue would they not like to know that a different version could potentially work for them?