With client's permission, here is how he fixed his problem:

"For you own reference here is what I believed happened and what I did. When Simply was upgraded it modified or deleted the .dlls files for the Adagio ODBC Driver. I went into the registry found the path pointing to the necessary .dll, followed the path and there was no .dll file as referenced in the registry key. I then deleted the registry entry for the Adagio driver, restarted the computer. After that I ran a repair through the Adagio installer and restarted to allow the ODBC to see the new ODBC connection driver update. After that Adagio was able to use the ODBC connection and retrieve the data."