Several configuration issues can complicate connecting successfully to an external database.
ODBC Version
Oracle Connectivity
GeoMedia Writing