I have found the one difference between the views that link and the ones that generate the above error; they use the aggregate function SUM() on a numeric field. After reviewing the FAQ (http://odbc.postgresql.org/psqlodbc.php?DocID=faq-microsoft) I tried casting these fields into the int4 type. This works and is fine for fields that I don't require any decimals for, but what about those that I do require decimals for?
Still searching for a workaround. Thankyou for your consideration.