title: Microsoft OLE DB Provider for ODBC Drivers error '80004005' when adding new site to IIS 7 when driver works for another site?
body: <p>I have a site that works as it should with my domain name(lets say it is <a href="https://mydoman1.se" rel="nofollow noreferrer">https://mydoman1.se</a>), and now I want to change the domainname to a new one (<a href="https://mydomain2.se" rel="nofollow noreferrer">https://mydomain2.se</a>) but still have <a href="https://mydoman1.se" rel="nofollow noreferrer">https://mydoman1.se</a> and redirect that to <a href="https://mydoman2.se" rel="nofollow noreferrer">https://mydoman2.se</a>.</p>
  <p>So I added a new site(<a href="https://mydomain2.se" rel="nofollow noreferrer">https://mydomain2.se</a>) in the IIS and copied all the setting for the new site from the old site(<a href="https://mydomain1.se" rel="nofollow noreferrer">https://mydomain1.se</a>)
  They are both pointing and using the same index.asp page.</p>
  <p>I use this Connection:</p>
  <pre><code>ConnString = &quot;DRIVER={MySQL ODBC 3.51 Driver}; SERVER='localhost';Port=3306; DATABASE='db_name'; &quot; &amp;_
  &quot;UID='uname';PASSWORD='pwd'; OPTION=3;&quot;
  </code></pre>
  <p>If I load <a href="https://mydomain1.se" rel="nofollow noreferrer">https://mydomain1.se</a> it works as it should, but if I load <a href="https://mydomain2.se" rel="nofollow noreferrer">https://mydomain2.se</a> then I get an error that it can´t find the Connection ?</p>
  <pre><code>Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] 
  Data source name not found and no default driver specified
  </code></pre>
  <p>I also added a system DSN and when testing it, it connects as it should. So why doesn´t it found it when I know I added it?</p>
  <p>I don´t understand why <a href="https://mydomain1.se" rel="nofollow noreferrer">https://mydomain1.se</a> is working and not the new one, they both use the same index file and Connection?</p>
  <p>What Im I missing? Does it have anything to do with 32 and 64 system?
  Any input really appreciated, thanks.</p>