>Long-time, no-see, David. How's it going?
>
>What does the following return:
>
>lnHandle = sqlstringconnect('Driver=Microsoft ODBC for Oracle;UID=Your_UserID;PWD=Your_Password;Server=ConnectionName;')
>
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