VBA ODBC Oracle Specified driver could not be loaded due to system error 193: (Oracle in instant client_11_2, C:\...\SQORA32.dll))
<p>I am trying to create an ODBC connection in a VBA script to an Oracle database, and I get the following error:</p>

<pre><code>Run-time error '-2147467259  (800004005)':
Specified driver could not be loaded due to system error 193: (Oracle in instantclient_11_2, C:\apps\oracle\11.2.0.3\instant-32\SQORA32.dll)
</code></pre>

<ul>
<li><p>When going to <code>%systemdrive%\Windows\SysWoW64\odbcad32.exe</code> I can see my driver "instantclient_11_2" and the file "SQORA32.dll" and it works perfectly when connecting to the db in Python.</p></li>
<li><p>When using regedit, in  <code>Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers</code> I can see the driver too.</p></li>
<li><p>Here is my code, I tried two different connection strings:</p>

<p>-<code>strCon = "DRIVER={Oracle in instantclient_11_2};DBQ=MyDBQ;UID=MyID;PWD=MyPWD"</code></p>

<p>-<code>strCon = "Driver={Oracle in instantclient_11_2}; " &amp; _
             "CONNECTSTRING=(DESCRIPTION=" &amp; _
             "(ADDRESS=(PROTOCOL=TCP)" &amp; _
             "(HOST=MyServer)(PORT=MyPort))" &amp; _
             "(CONNECT_DATA=(SID=MySID))); uid=MyID;pwd=MyPWD;"</code></p></li>
<li><p>My MS Excel version is in 32 bits and so is my driver (SQORA32.dll) so I assume it doesn't have anything to do with a 322/64 versions problem, but I may be wrong.</p></li>
</ul>

<p>Any help/advice/solution is welcome.</p>