🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1217

Re: paradox, ms access, ADO etc.

#1217
From: Viatcheslav V. Vassiliev
Date: Wed, 22 Sep 2004 07:09
94 lines
4592 bytes
1. Firebird is better (more powerfull), 2. MySQL is not free (look its
license) - I think it is important for you.

Firebird is based on Interbase 6.0 OpenSource but after that it is another
branch than Interbase. For components, search on http://www.ibphoenix.com/
(for example,
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_dev_comps) - there is
list of components for Delphi/BCB. Not sure about components for BCB 3.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Sudesh" <sudeshc@vfemail.net> �������/�������� � �������� ���������:
news:41510846@newsgroups.borland.com...
> Hi Vassiliev:
>
> What would be better choice betn. Firebird and MySQL?
> Firebird is the same Interbase?
> Are there BCB components available for both?
>
> Thanks,
> Sudesh
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:41502b05@newsgroups.borland.com...
> > Normal DBMS such as Firebird, Interbase, MS SQL Server etc.
> >
> > Firebird is free, open source and has small install, MSDE (desktop
version
> > of MS SQL Server) is installed with MS Office, MS Visual Studio and some
> > other MS products. MSDE is redistributable (look
> > http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp) but has
> > restriction
> > for 5 concurrent connections (after that it will artifically slow
down) -
> > it
> > is usually enough for 50 actual users, and 2 GB databases.
> >
> > //------------------------------------------
> > Regards,
> > Vassiliev V. V.
> > http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> > ADO.Net
> > http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> > MS Jet (Access) and Interbase (through OLEDB)
> >
> > "Sudesh" <sudeshc@vfemail.net> �������/�������� � �������� ���������:
> > news:41501880@newsgroups.borland.com...
> >> Hi Viatcheslav:
> >> Thanks for your reply.
> >> So whats better when 50+ users are expected to access the database?
> >> Thanks
> >> sudesh
> >>
> >> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> >> news:41500aa9@newsgroups.borland.com...
> >> > BDE is deprecated by Borland, Access is deprecated by Microsoft. But
> >> > unlike
> >> > BDE, there are updates for Jet. Access is used more wide and will
have
> >> > quite
> >> > long life before completely going out. For Access, ADO is better. DB
> > size
> >> > is
> >> > limited to 2 GB, but if you do not compact it periodically, it will
> >> > only
> >> > grow, so real max. is 500 MB - 1 GB. Max. concurent users is ~ 5-10.
> >> >
> >> > //------------------------------------------
> >> > Regards,
> >> > Vassiliev V. V.
> >> > http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> >> > ADO.Net
> >> > http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> >> > MS Jet (Access) and Interbase (through OLEDB)
> >> >
> >> > "Sudesh" <sudeshc@vfemail.net> �������/�������� � �������� ���������:
> >> > news:414fdaa0@newsgroups.borland.com...
> >> >> no reply from anybody?? :-(
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>
Technical Details
Message-ID: <41512535$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <414da6a7@newsgroups.borland.com> <414fdaa0@newsgroups.borland.com> <41500aa9@newsgroups.borland.com> <41501880@newsgroups.borland.com> <41502b05@newsgroups.borland.com> <41510846@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,616d90cb49454cd3
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <414da6a7@newsgroups.borland.com> <414fdaa0@newsgroups.borland.com> <41500aa9@newsgroups.borland.com> <41501880@newsgroups.borland.com> <41502b05@newsgroups.borland.com> <41510846@newsgroups.borland.com>
Subject: Re: paradox, ms access, ADO etc.
Date: Wed, 22 Sep 2004 11:09:42 +0400
Lines: 96
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 213.234.218.42
Message-ID: <41512535$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1095836981 213.234.218.42 (22 Sep 2004 00:09:41 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail