> I am looking for some advice. Currently we have a real time system that is
> running off Paradox as the back end. It appears however that the DBMS is
> getting close to its use by date so a "real" DBMS is being considered (Why
> now only was my question too). At present the contenders are:
>
> - MS-SQL7
> - Interbase 5.x
> - MySQL
My personal preference would be to add ORACLE onto this list above MSSQL
MySQL I've been told doesn't implement as much of the nest query facilities as some
of these others...
> My only previous experience is with M$ so I need to broaden my perspective
> here. IB & MySQL have the benefit of having Linux cousins so they have an
> advantage there. IB also has IBX. Can someone tell me about there
> experiences with IBX?? In not using the BDE what does it use? Can IB also be
> accessed via ADO? Is ADO the new route to go down in terms of DB access??
I've trialled ORACLE through ADO without incident and I believe there is supposed to
be linux support (avialable or coming?) for ORACLE.
ORACLE 8 has a reasonable set of administration tools to bring it up with MSSQL and
has no problems with limited resources or huge databases - scalability is endless...
I haven't used but have at least previewed nested table and custom datatype support for
ORACLE8 in the BDE and this looks quite nice also...
Does anyone know if the ORACLE8i implementation includes implementing stored
procedures in Java as part of its facilities?
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
