Have you tried using the MSDAORA provider instead of MSDASQL?

Here is a tutorial from 2006 that should still be relevant for SQL 2008.