Is the ODBC driver 32bit or 64bit, on Windows 8? Is it configured to connect through hiveserver2?
When you query with hive client, it does not go through hiveserver2. Can you try query locally using beeline
beeline> !connect jdbc:hive2://$your-hiveserver-host:port $user org.apache.hive.jdbc.HiveDriver
and see if you can run the query from beeline?
if you do lsof -i :$hiveserver2-port, do you see connection from the ODBC host to hiveserver2?
By default hiveserver2 uses port 10000.
Also anything in the hiveserver2 log side?