title: iis7, classic asp; type mismatch error
body: <p>I've setup a local server on Windows 7 with IIS 7, for a classic ASP VBS site I'm working on.</p>
  
  <p>A page gives me a "type mismatch" error. This doesn't happen with the original server (Windows 2008, IIS 7)</p>
  
  <p>related code:</p>
  
  <pre><code>if myRS("age") = 10 then
  </code></pre>
  
  <ul>
  <li>The field value is an empty string, checked with a debugger, also the error states 'string'</li>
  <li>The ASP file, database &amp; the data are exact copies of the production site</li>
  <li>No error resuming in both the public and the local sites.</li>
  <li>The production server is MS-SQL 2008 R2 web edition, where the local one is Express Edition.</li>
  </ul>
  
  <p>Now I know the code is terribly written. But how can the local server gives such an error and the public server does not? I think comparisons are made through variant type, so subtypes should be automatically evaluated with no errors?</p>