title: ODBC issue with SQL-Server date field when migrating from XP32 to Win7 64
body: <p>I am running an SQL pass-through query in SAS.</p>
  
  <p>When I run it on my 32bit WinXP box, the date field in the final SAS table is numeric.</p>
  
  <p>When I run it on my 64bit Win7 box, the date field in the final SAS table is character.</p>
  
  <p>Has anybody else experienced this problem?  How can I get the 64bit version to always return numeric (preferably without changes to the code as we are migrating environments)?</p>
  
  <p>Thanks
  Rob</p>
  
  <pre><code>proc sql noprint;
    connect to odbc as remote (datasrc=xxx);
    create table table1 as 
    select *
    from connection to remote
    (
    select cast(date_created as date) as date,
           count(*) as count
    from mydb.dbo.mytable
    group by cast(date_created as date)
    order by date
    )
    ;
    disconnect from remote;
  quit;
  </code></pre>
  
  <p><br><br><B>SOLUTION:</b> Needed to install "SQL Server Native Client 10". Download the 64bit installation here:</p>
  
  <p><a href="http://www.microsoft.com/download/en/confirmation.aspx?id=16177" rel="nofollow">http://www.microsoft.com/download/en/confirmation.aspx?id=16177</a></p>
  
  <p>Then re-setup DSNs using that new driver and that fixed it. </p>