>>Could it be that 1521 (or whatever port is being used) has been setup only one-way?
>>
>
>The firewall guys claim that all ports are open right now and I don't know of any way to verify this.
>
>Also, back when I set this application up originally, it seemed like the ports change randomly due to Oracle being run on an NT platform (even though the TNSNAMES.ORA config file specifies 1521), and I think we ended up opening a block of ports.
>
>It was also my previous experience that whenever I could get SQLPLUS to work, the VFP ODBC connection would work as well. What is unique about VFP that this firewall is handling it different then other apps?

There really is not anything different. SQL Plus only uses the SQL Net client. It does not use ODBC. VFP uses ODBC with the SQL Net client. That is the only difference. It can't be that port 1521 or whatever port you have the server using is configured for one way. If it was then SQL Net would also fail. THis limits the problem to a combination of the ODBC drivers and the Router. I say both are involved because you had no problems before or with other machines outside the firewall. There is some incompatibility between the two, and I'll be danged if I know what that would be.