Oracle tech support will not work any more on this since:

1) My app is still working perfectly for clients that are out of the office not passing through the Checkpoint firewall proving that the server is alive and well listening for requests.

2) The Oracle ODBCTST.EXE connects just fine through the Checkpoint firewall suggesting that the TNSNAMES.ORA file and ODBC drivers are OK.

3) SQLPLUS and OEM software is working perfectly through the firewall once again suggesting that connectivity exists and the server is working.

Also, I have seen the same 12204 Oracle error before when I was trying to get the original firewall to work. Once the firewall and the TNSNAMES.ORA file was configured properly, the 12204 error went away. The only difference now, however, is with the Raptor firewall, even SQLPLUS would give me the 12204 error when things were not working.

I have also had the firewall guys check info from the firewall vendor, however, so far nothing useful has turned up.

I think the solution will come if I can find something unique about how the firewall is handling VFP.

Thanks,
David

>Damn, you got one bizarre problem. This makes no sense regarding why the connection is failing via ODBC. What does is the info in aerror() provide? This is what the definition of the error is according to Oracle:
>
>TNS-12204 TNS:received data refused from an application
>
>Cause: The application using the Interchange or Connection Manager refused the connection at the listener.
>
>Action: Make sure that the application listener at the destination is functioning correctly. If it is and the problem persists, contact Oracle Customer Support.
>
>This makes me think something is actually reaching the server [the listener is on the server], but the listener can not determine the source to reply back to. Which leads me to believe that it very well could be the router. I would provide the Oracle port that the server is using, and see if there is some problem with accessing that port with respect to your new router. I know next to nothing about routers except for the one I have for my DSL modem that acts as my firewall.
>
>>Hi Mark,
>>I've been beyond busy as usual.
>>
>>I've tried SQLSTRINGCONNECT() and it is behaving exactly the same as SQLCONNECT() where the returned handle is -1 and the Oracle error is 12204.
>>
>>Also, there's a couple of points I forgot to include in my original post:
>>
>>1) The exact same VFP application and ODBC drivers are still functioning on client computers outside the office that connect to the Internet without the Checkpoint firewall.
>>
>>2) The firewall guys say they are convinced that the firewall has all ports open and is not configured to only allow applications with a certain name to communicate.
>>
>>Thanks
>>David