title: Recordset (classic asp) storing empty values after executing SQL Server stored procedure
body: <p>I have restored a database from SQL Server 2005 to SQL Server 2014. I am trying to execute a stored procedure from a classic ASP application. </p>
  
  <p>After execution, the recordset stores a few column values as empty and a few columns with proper values. If I execute the the stored procedure in DB, it works fine, I get the correct values for all the columns. </p>
  
  <p>While debugging, I quick watch those columns which get empty values and found that Actual Size is set to -1. </p>
  
  <p>Why is it showing Actual size = -1 ? Is there any column data type compatibility issue between 2005 and 2014 ? E.g. I have datatypes such as <code>varchar(max)</code>, <code>shortdatetime</code> etc. </p>
  
  <pre><code>Set ObjRs = ObjConn.Execute("lp_view " &amp; id)
  ORD = ReadDate(ObjRs("Date"))
  Addr = (ObjRs("address"))
  </code></pre>
  
  <p>Both ORD and Addr = empty. The column Date &amp; address have some values in the database.</p>
  
  <p><img src="https://i.stack.imgur.com/XGsLt.png" alt="enter image description here"></p>