title: How do I connect to my 64-bit SQL Server with ODBC?
body: <p>I recently installed SQL Server 2008 Express on my Windows 7 Ultimate x64 home machine. I also have IIS 7.5 with PHP 5.3, and I was trying to connect to SQL via <a href="http://adodb.sourceforge.net/" rel="noreferrer">ADODB</a>, but kept getting this error:</p>
  
  <pre><code>[Microsoft][ODBC Driver Manager] The specified DSN contains an
  architecture mismatch between the Driver and Application
  </code></pre>
  
  <p>After doing a small amount of digging on the internet, I think this is because the SQL Server ODBC driver is meant for 32-bit operating systems, and mine's 64. First of all, am I correct? Is this the reason I'm running into trouble? Secondly, if so, how do I fix this? Are there any updated ODBC drivers that work with 64-bit operating systems? I looked but was unable to find any...</p>