Even Oracle doesn't provide an ODBC driver for classic MacOS. (!) A choice would be to use DBI-proxy. I have no idea whether this works but remember quite a lot of traffic regarding this topic on this list. Just browse the archive or test it yourself.
Kind regards, Axel