>Thanx for the response. This has all been extremely informative but I still have the original problem: How do I stop the "Executing Remote... Press ESC to cancel." message from appearing? It shows up no matter how I set the Asynch mode or the fetch size. Any ideas? thanx again!
This is what I do to connect to my Oracle database:
=DBSETPROP(gcRemoteConnection, "CONNECTION", "DispLogin", DB_PROMPTNEVER)
=DBSETPROP(gcRemoteConnection, "CONNECTION", "DispWarnings", .F.)
=DBSETPROP(gcRemoteConnection, "CONNECTION", "UserId", lcUid)
=DBSETPROP(gcRemoteConnection, "CONNECTION", "PassWord", lcPw)
WAIT WINDOW NOWAIT "Connecting to Oracle, Please Wait..."
gnRemoteHandle = SQLCONNECT(gcRemoteConnection)
WAIT CLEAR
I have the connection set to asynchronous. I have a form that asks for the user id and password (lcUid and lcPw are set from form properties). I don't get the message you are talking about. I have, however, seen the message in the development environment using the default VFP settings.