If you have all the necessary bits and pieces, yes. Here's how a typical HS setup might work (without full transparent gateway options).
(In all of this, X, Y etc might all be the *same* node - just depends on what you've got installed where)
You have an ODBC setup on node Y that can talk to Foxpro. We'll call this connection FOX_ACCESS (that would be setup in the standard ODBC-config screens)
You have a database on node X.
So the database on node X needs to be talk to node Y in order to get to Foxpro.
Node X will have a tnsnames.ora entry similar to this:
FOX_REMOTE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =nodeY)(PORT = 1521))
(CONNECT_DATA =
(SID = getfox)
)
(HS = OK)
)
Now nodeY needs to *listen* for those reqests, so it will need an Oracle listener process running with a listener.ora file similar to do:
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=....)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4odbc)
(ORACLE_HOME=c:\oracle\product\12.1.0.2)
(PROGRAM=dg4odbc)
)
)
So nodeY is "offering out" HS facilities to people who in on port 1521.
When nodeX contacts nodeY as says "I want to talk to 'getfox'", nodeY will look for a file called initgetfox.ora under $ORACLE_HOME/hs/admin. Inside that file will be something like this:
HS_FDS_CONNECT_INFO = FOX_ACCESS
HS_FDS_TRACE_LEVEL = 0