Article View: borland.public.cppbuilder.database.ado
Article #3094Re: Must I use a third-party ADO component ?
From: Vassiliev V.V.
Date: Tue, 17 Dec 2002 07:44
Date: Tue, 17 Dec 2002 07:44
97 lines
4511 bytes
4511 bytes
Yes, you can use dbExpress with Access if you will have dbExpress driver. Borland has no dbExpress driver for Access. One available is OLEDBExpress from http://www.oledbdirect.com/oledbexpress. But anyway I recommend ADO (or OLEDB without ADO such as in OLEDB Direct for high-speed access) for MS Access database. ---------------------------------------------------------------- Regards, Viatcheslav V. Vassiliev http://www.oledbdirect.com The fastest way to access MS SQL Server, MS Jet (MS Access) and Interbase (LCPI provider, http://ibp.lcpi.lipetsk.ru) databases. "Jonathan" <jl344322@yahoo.com> ???????/???????? ? ???????? ?????????: news:3dfe397e@newsgroups.borland.com... > Vassiliev V.V. wrote: > > C++ Builder 6 includes dbGo - ADO components (look tab ADO in IDE). You are > > clients do not require latest MDAC unless you use features that are > > available only in it. But, of course, having latest updates will make your > > program more stable and, may be, faster (if update has bug-fixes). Your > > clients may need Jet Service Pack (can be download from > > http://www.microsoft.com/downloads). > > > > For dbExpress you will need third-party dbExpress driver for MS Jet > > (Access). In BCB6 you will need third-party driver even for MS SQL Server > > (Borland's one will be included with BCB7). > > > > ---------------------------------------------------------------- > > Regards, > > Viatcheslav V. Vassiliev > > http://www.oledbdirect.com > > The fastest way to access MS SQL Server, MS Jet (MS Access) > > and Interbase (LCPI provider, http://ibp.lcpi.lipetsk.ru) databases. > > > > "Jonathan" <jl344322@yahoo.com> ???????/???????? ? ???????? ?????????: > > news:3dfddd20@newsgroups.borland.com... > > > >>Vassiliev V.V. wrote: > >> > >>>Look for third-party ADO components. One of them is OLEDB Direct > >>>(http://www.oledbdirect.com) - it does work with OLEDB - lower level > > > > than > > > >>>ADO. If you do not need TDataset descendant you can just import ADO type > >>>library (Project\Import type library in menu and choose "Microsoft > > > > ActiveX > > > >>>data objects 2.x library") and work with ADO as with COM object. > >>> > >>>---------------------------------------------------------------- > >>>Regards, > >>>Viatcheslav V. Vassiliev > >>>http://www.oledbdirect.com > >>>The fastest way to access MS SQL Server and MS Jet (MS Access) > > > > databases. > > > >>>"ymps" <ymps@public.lnptt.sd.cn> �������/�������� � �������� ���������: > >>>news:3ddc6bb0$1@newsgroups.borland.com... > >>> > >>> > >>>>How to access MS-ACCESS database using ADO in C++ Builder 4 ? > >>>> > >>>> > >>> > >>> > >>> > >>Is it the same answer for C++ Builder 6 Pro ? > >>Must I use a third-party ADO component ? > >> > >>Jonathan. > >> > > > > > > > > Thank you Viatcheslav V. Vassiliev for your reply. > > I just don't understand, if I use the dbGo component, may I use an > Access 2000 MDB as a data holder ? > As a file to store the data, so I'll be able to update it with the dbGo > component ? > > I need no more than simply to add/delete table(s) and to add rows. > Not even COUNT/JOIN or something like that, simply SQL queries will do here. > > Thanks, > > Jonathan. >
Technical Details
Message-ID:
<3dfed6e7@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!oleane.net!oleane!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3ddc6bb0$1@newsgroups.borland.com> <3ddc8eec@newsgroups.borland.com> <3dfddd20@newsgroups.borland.com> <3dfe1902@newsgroups.borland.com> <3dfe397e@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,fdfdbd3ac24b3ed8 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-12-17 00:08:59 PST From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> Newsgroups: borland.public.cppbuilder.database.ado References: <3ddc6bb0$1@newsgroups.borland.com> <3ddc8eec@newsgroups.borland.com> <3dfddd20@newsgroups.borland.com> <3dfe1902@newsgroups.borland.com> <3dfe397e@newsgroups.borland.com> Subject: Re: Must I use a third-party ADO component ? Date: Tue, 17 Dec 2002 10:44:19 +0300 Lines: 99 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 212.188.98.123 Message-ID: <3dfed6e7@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1040111335 212.188.98.123 (16 Dec 2002 23:48:55 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!oleane.net!oleane!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail