This question is locked. New answers and comments are not allowed.
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
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
1 Answer, 1 is accepted
0
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.
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.