Unfortunately, I don't have any direct experience with Oracle 8.0 yet. :(
Our system is due for update in April 2000.

Are you using the Connection Designer or are you creating the connection in code?

I found exactly the same problem you are experiencing when I used the Connection Designer. I clicked the "Display warnings" option in the Data Processing section of the Connection Designer and now I get the same error message you see. I also get the error "Warning: the query timeout cannot be set." I played with different timeout settings and found nothing that solved the problem. AERROR() reports a syntax error with an error number of 10. I'm thinking that the error message must be internal to FoxPro. If it was an ODBC error or an Oracle error being passed on by the ODBC driver, it should say something like "Microsoft][ODBC driver for Oracle]" followed by an error message. If I turn off the "Display warnings" option, the problem goes away. That would be the same as using

=DBSetProp('MYCONNECTION', 'Connection', 'DispWarnings', .F.)

in code. Turn the Display warnings off and use AERROR() to trap for errors instead. Open the remote view and then check AERROR(). As a work-around, you could do something like this:

DIMENSION errorarray[1,1]
USE MyRemoteView
AERROR('errorarray')
DO CASE
CASE errorarray(1) = 1526
ErrorMessage = 'TNS: unable to connect to destination. Check connection or rerun SQL Net Easy Configuration.'
** Do something.
CASE errorarray(3) = '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'
ErrorMessage = 'MDSDB data source name not found and no default driver specified.'
** Do something.
*
*
* Add more error messages here
ENDCASE

You could put the error messages into a MessageBox or add a list of likely Oracle errors to your objects Error() method or to your general error handler.

I hope this helps.

Gregg

>Hi Gregg,
>
>I am having a similar problem with Oracle 8.0.
>
>We make the connection to the Oracle database and with "messages" turned on we get the warning (cannot make sync/async connection) then we can make query's but cannot update to the server. We are using remote views.
>
>I tried SQLpassthru and it updated the table fine.
>
>Any ideas?
>
>Thanks,