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.

    Ellen.


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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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