Do not use ODBC. Use an Oracle JDBC driver and connect using it (there are type 4 Oracle JDBC drivers, so there is absolutely no issue using them).
It might not immediately solve your problem, but it will eliminate ODBC (which is messy) from the picture. The rest will be considerably easier to solve. Also, there are other ODBC related incompatibilities and other problems that are best to be avoided.
We also have an Oracle FAQ page which might help you.