I managed to get the sample working at the clients. I had installed into a new directory away from their C:\Softrak\ and I deleted and re-created the DSN. It occured to me that if I didn't delete and re-create the DSN it could be pointing to a different AdagioODBC driver.

So I can load the Sample data now. I am still having problems with the company data but I think I'm in the realm of talking with the client's Adagio Var and it might simple be a setup or pathing issue.