Article View: borland.public.cppbuilder.database.ado
Article #1216Re: paradox, ms access, ADO etc.
From: Sudesh
Date: Wed, 22 Sep 2004 05:06
Date: Wed, 22 Sep 2004 05:06
70 lines
3570 bytes
3570 bytes
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:
<41510846@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!newsfeed.icl.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<414da6a7@newsgroups.borland.com> <414fdaa0@newsgroups.borland.com> <41500aa9@newsgroups.borland.com> <41501880@newsgroups.borland.com> <41502b05@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: "Sudesh" <sudeshc@vfemail.net> 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> Subject: Re: paradox, ms access, ADO etc. Date: Wed, 22 Sep 2004 10:36:10 +0530 Lines: 72 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2096 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2096 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 220.224.15.16 Message-ID: <41510846@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1095829574 220.224.15.16 (21 Sep 2004 22:06:14 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!newsfeed.icl.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail