🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: paradox, ms access, ADO etc.

#1215
From: Viatcheslav V. Vassiliev
Date: Tue, 21 Sep 2004 13:22
54 lines
3119 bytes
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: <41502b05@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!in.100proofnews.com!in.100proofnews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <414da6a7@newsgroups.borland.com> <414fdaa0@newsgroups.borland.com> <41500aa9@newsgroups.borland.com> <41501880@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>
Subject: Re: paradox, ms access, ADO etc.
Date: Tue, 21 Sep 2004 17:22:12 +0400
Lines: 56
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: <41502b05@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1095772933 213.234.218.42 (21 Sep 2004 06:22:13 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!in.100proofnews.com!in.100proofnews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail