During the upgrade from SP6 to SP8, the ODBC connection stopped working.
After some investigation, the admin folder was missing after upgrade.
Copying the ODBC/admin folder from the SP6 servers (non-upgraded) to the SP8 (upgraded) system, solved the issue.