title: Error with classic asp database connection after migration of website from IIS6 to IIS7
body: <p>I have a classic asp site which has the following database connection:</p>
  
  <pre><code>&lt;%
  set objConnection = Server.CreateObject("ADODB.Connection")
  objConnection.ConnectionString = "Driver={SQL Server};Server=123.456.789.012;Database=mydatabase;Uid=myuser;Pwd=123xyz;"
  objConnection.Open
  %&gt;
  </code></pre>
  
  <p>The site has just been moved from a Windows 2003 server running IIS6 to a Windows 2008 server running IIS7 (both using MSSQL 2005 Express database) and it now gives an error message:</p>
  
  <pre><code>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
  [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.
  /inc/dbconnection.asp, line 4 
  </code></pre>
  
  <p>I'm assuming it's because there's a different driver with IIS7?  What would be the updated connection string to get this to work - I've googled and just not found anything that works or makes sense to me (I'm at the edge of my understanding here to be honest!)?</p>
  
  <p>Many thanks for any pointers folks...</p>