DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Oracle and ADODC

  1. #1
    Janet Guest

    Oracle and ADODC

    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.

  2. #2
    Ellen Khlystova Guest

    Re: Oracle and ADODC

    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center