Selecting "real" columns makes queries fail silently

Question

Selecting any column of type "real" makes my query fail silently. This seems like a major problem to me.

I posted another question earlier today, with code and explanations, but it turns out it's as simple as this. Casting to float "fixes" the problem, except you can't always do that (for example with stored procedures).

Answer 1

Please check that SQL Server Native Client 10 (SNAC 10) installed is version 10.00.2531 or later. Version 10.00.1600 had a bug on handling “real” numbers (very similar to the behavior reported in your post).

The SNAC 10 version required is the one included in the Microsoft SQL Server 2008 Feature Pack, April 2009.

http://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en

Hope this helps,

Serban

---

Serban Iliescu - MSFT

Answer 2

Thanks, this solved the problem.

However, I downloaded that broken version from Microsoft's website very recently. Maybe it's just me, but I wouldn't consider that version production-ready.

It should be removed or at least carry a warning, I spent a few hours on this, thinking the problem was in my code at first.

Again, thanks for the help.

---

(reposted, sorry about the double threads but this is in case anyone else finds this topic in a search or something)