which version of VC++ 2010 redistributable package have you installed (32 bit or 64bit)?
Since you want to connect from 32bit version of Excel, you should have 32bit version of Oracle ODBC driver, VC++ 2010 redistributable package x86 in your environment.
Make sure you have the right combination.
Thanks & Regards,
thank you for your help,
actually both x86 and x64 VC++ 2010 redistributable packages were already installed on the machine, on version 10.0.40219 .
Have you invoked the right version (32bit version) of ODBC Data source administrator to configure. For 32bit ODBC, you need to invoke C:\Windows\SysWOW64\obdcad32.exe.
Yes, double checked it, I'm using the 32-bit version of odbc data source administrator (the one found under C:\Windows\SysWOW64\odbcad32.exe), but still got the same message,
You say you have instantclient_12_2 and the 2010 redistributables. However (from the Instant Client download page) you need the 2013 redistributables with 12.2
Install Microsoft Visual Studio 2013 Redistributable package over 12.2 Oracle client/instant client homes.
It can be downloaded from the below location: