title: Upgraded from IIS6 to IIS8 now SQL statement no longer working
body: <p>Thanks for the help</p>
  
  <p>I have recently upgraded from IIS6 to IIS8 and all of my web applications are working correctly except 1. </p>
  
  <p>I have an adodb.connection and it is no longer pulling the correct data from my database. Nothing on the database side has changed. </p>
  
  <p>it looks like it is rounding down on my numbers but I am not sure why it is doing that. </p>
  
  <p>here is my query</p>
  
  <pre><code>Set OBJdbConnection = Server.CreateObject("ADODB.Connection")  
  OBJdbConnection.Open "DSN=DSNNAME;UID=UIDNAME;PWD=password"
  OBjdbConnection.CommandTimeout=0
  SQLQuery = "SELECT ACDESC, substr(POINTS,1,5) as Field, AHDATE, AHEMPN, AHCODE, EENAME, YAED10 
  FROM (((CKATRCODL1 INNER JOIN CKATRHIS ON ACCODE=AHCODE) 
   INNER JOIN CKEMPLMS ON AHEMPN=EEEMPN) INNER JOIN EMPNOS ON 
  EEEMPN=OEMP#) INNER JOIN F060116 ON NEMP#=YAAN8 WHERE AHEMPN=" &amp; 
  EmpNum &amp; " ORDER BY AHEMPN, AHDATE"
  Set R1 = OBJdbConnection.Execute(SQLQuery) 
  </code></pre>
  
  <p>thanks in advance.</p>