Article View: borland.public.cppbuilder.database.ado
Article #1217Re: paradox, ms access, ADO etc.
From: Viatcheslav V. Vassiliev
Date: Wed, 22 Sep 2004 07:09
Date: Wed, 22 Sep 2004 07:09
94 lines
4592 bytes
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-mailReferences:
<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