title: Specifying version of Microsoft ODBC for Oracle (32/64 bit) in connection string for DSN-less connection (Access 2013 (32 bit))
body: <p>Per</p>
  
  <p><a href="http://www.accessmvp.com/djsteele/DSNLessLinks.html" rel="nofollow">http://www.accessmvp.com/djsteele/DSNLessLinks.html</a></p>
  
  <p>I've attempted to replace DSN-created table defs in Access with a <strong>DSN-less connection.</strong></p>
  
  <p>No luck trying the driver from Microsoft:</p>
  
  <p><strong>Microsoft ODBC for Oracle</strong></p>
  
  <p>because of this specific issue:</p>
  
  <p><a href="https://support.microsoft.com/en-us/kb/942976" rel="nofollow">https://support.microsoft.com/en-us/kb/942976</a></p>
  
  <p>On Windows 7 64 bit, you have to manage the ODBC driver (DSN) using the 32 bit ODBC Admin panel, if you want to use <strong>Access 2013 32 bit</strong>.</p>
  
  <p>However, that doesn't solve the issue because I'm trying to <strong>go DSN-less</strong> in the first place.</p>
  
  <p>I assume that the reason the connection doesn't work is that Windows is "helpfully" choosing the 64-bit version of the driver when I use this as my connection string:</p>
  
  <pre><code>strConnectionString = _
      "ODBC;DRIVER={Microsoft ODBC for Oracle};" &amp; _
      "Server=" &amp; ServerName &amp; ";" &amp; _
      "UID=" &amp; UID &amp; ";" &amp; _
      "PWD=" &amp; PWD &amp; ";"
  </code></pre>
  
  <p>The issue is I can't specify that I want the 32-bit version of the driver, because <strong>both versions</strong> (32 and 64) <strong>have the same name</strong>.</p>
  
  <p>Is there a way around this?</p>
  
  <p>Thanks,
  Chad.</p>