Oracle and ADODC

[Janet]

I am getting the error message:

"ORA-00933: SQL command not properly ended"

when the recordsource property of my data control has a where clause. There
is no error when I remove the where clause. I am using the Oracle OLEDB
provider MSDAORA. Any information anyone has would be appreciated. Thanks.

[Ellen Khlystova]

This sounds like a problem with quotes or some other special characters in
the WHERE clause.

Copy the entire statement into an interactive ORACLE interface ( like SQL
Worksheet, for example ) and keep editing until it executes. Then copy it back,
adding quotes around it, if necessary.

Ellen.