in reply to Need DBI/ODBC advice.

If the only thing that changed is the SQL server, then that implies the SQL server has changed the way it's delivering the data. Your solution would then either include some sort of "compatibility mode" or other configuration on the server to get the old behavior back, or something on the other end to convert those floats to ints.

I'd go search google for changes between SQL server 2005 vs. SQL server 2008.