🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Must I use a third-party ADO component ?

#3094
From: Vassiliev V.V.
Date: Tue, 17 Dec 2002 07:44
97 lines
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-mail
References: <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