>>>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.
>
>What is contained in gcRemoteConnection?
This is the name of my remote connection. This appears in the project manager on the Data tab under Connections.