Open Access 4.3 Oracle Requirements

2 posts, 0 answers
  1. Joao
    Joao avatar
    1 posts
    Member since:
    Sep 2008

    Posted 14 Aug 2009 Link to this post

    I still use open Access 4.3.0.378 with oracle 10gR2.

    I'd like to know if this 4.3 version works with oracle 8.1.7 . I'm having problems with open access queries ...

    RT.Adonet2Generic.Impl.DBDriverException: Preparation failed for 'SELECT a.ID FROM DAILY_TRIP_ROSTER a JOIN BASE_TRIP_ROSTER b ON (a.BASE_ROSTER_ID = b.ID) WHERE EXISTS (SELECT 1 FROM USER_PROFILES c WHERE EXISTS (SELECT 1 FROM DEPOT_USER_PROFILES d JOIN DEPOT e ON (d.DPT_ID = e.ID) WHERE c.ID = d.USRPF_ID AND c.ID = :p0         AND a.ROSTER_DATE > :p1 AND b.DEPOT_ID = e.ID)) '

    Oracle 8.1.7 doesn't like open access's  sql JOIN .

    thanks in advanced

    Joao Castro

  2. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 17 Aug 2009 Link to this post

    Hi Joao,
    OpenAccess does not support Oracle 8. Your analyzation is right, with the switch to the ANSI join syntax we lost the Oracle 8 funtionality.

    Best wishes,
    Jan Blessenohl
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. DevCraft banner
Back to Top