"Donovan J. Edye" wrote:
>
> G'Day All,
>
> 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
Ouch. Please no. Especially for a realtime app - even more so if it
needs 24x7 uptime.
> - Interbase 5.x
:) but I'm biased. Talk to Tony Blomfield tho :) ([EMAIL PROTECTED] -
also on the list)
> - MySQL
No experience with it, myself, tho I've heard is very restrictive.
>
> 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??
Mine are good, so far. Tell you more in a day or 2, 'cos I'm about to do
an app that uses it.
> In not using the BDE what does it use?
Direct calls to the IB client library - ala using DBLIB directly to
MSSQL, rather than ADO -> OLEDB -> DBLIB -> MSSQL or ODBC -> DBLIB ->
MSSQL
Inprise has now abstracted the dataaware controls out, too, so it works
just the same way (once setup, ie, its not the same to connect to a db)
as a BDE connection, eg:
TIBDatabase -> TIBTable -> TDataSource -> TDBWhatever
> Can IB also be
> accessed via ADO?
Yes, in IB6. Or so I'm told. Otherwise, via the ADO -> ODBC driver
thing.
>Is ADO the new route to go down in terms of DB access??
If you are MS centric, yes. Otherwise, whatever works for you. I like
IBX myself, but if I was using Access or MSSQL, I'd go with ADO (even,
maybe, for oracle, if I didn't have the DOA driver (Direct Oracle
Access)
>
> Any pointers, suggestions, FAQs, ReadMe etc. would be greatly
> appreciated.......
I'll email yo something I wrote privatly - its an IB vrs MSSQL
comparison, tho it is pretty marketing orientated with a techie edge. If
anyone else wants it (.pdf), mail me ([EMAIL PROTECTED])
N
--
Nic Wise - Inprise/Borland New Zealand
mob:+64.21.676.418 - wk:+64.9.481.9999 x9753 - wk-em:[EMAIL PROTECTED]
hm: +64.9.277.5309 - hm-em:[EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
