Article View: borland.public.cppbuilder.database.ado
Article #1215Re: paradox, ms access, ADO etc.
From: Viatcheslav V. Vassiliev
Date: Tue, 21 Sep 2004 13:22
Date: Tue, 21 Sep 2004 13:22
54 lines
3119 bytes
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-mailReferences:
<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