If the remote access is the requirement, rather than ODBC specifically, consider using JDBC to speak directly to the database. Oracle ships multiple JDBC libraries--you'd want the ones that speak native Oracle (OCI?) across the network to the 2000 box.what is a good library to use for ODBC? what are any of the dependency (additional lib, rh o/s or oracle db version/platform dependency, etc).
Specifically... On a linux rh 7.1 machine, i want to extract data residing on another machine (oracle db 8.x on windows 2000). It does not have to be a rh lib but preferred.