🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Question for compress Access DB

#3183
From: Vassiliev V.V.
Date: Mon, 02 Dec 2002 07:59
199 lines
7475 bytes
PATH is evironment variable that is defined in Windows. It is in
autoexec.bat for Windows 9x and on Windows 2000/XP:
Choose MyComputer icon on desktop, right click, choose Properties, choose
Additional (or Optional or something so, I do not use english Windows) tab,
choose Environment variables button, edit PATH.

I do not have your project, so you should look where you have duplicated
links yourself.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server and MS Jet (MS Access) databases.


"Daryl" <stockd@cqnet.com.au> �������/�������� � �������� ���������:
news:3deb0cd4@newsgroups.borland.com...
> Vassiliev
> Thanks for the tips - I have to ask the PATH you refer to, could you
please
> be more specific.  I know of the Directories/Conditionals under Options
> under Projects - Is that the one you refer to?
>
> BTW - I did as you suggested but I have a problem with a Linker error -
> indicating that Public symbol 'Jro_tlb::IID_IJetEngine' defined in both
> module F:\...\MAIN.OBJ and F:\...\DMVSTORE.OBJ Note: it does this for
about
> 7 Public Symbols...
>
> I have made my DataModule a Friend class of my Main Unit so it can use its
> private methods, this could be the reason also both Units have each of the
> others included in their respective header files - I have to admit that I
> have never had any problems with the Linker so my knowledge is very, very
> limited.  Any more hints, even a pointer in the right direction would be
> good.
>
> Thanks
> Daryl
>
>
> "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
> news:3dea0d97@newsgroups.borland.com...
> > Include Jro_tlb.cpp into your project (you can get it by importing Jet
> type
> > library).
> >
> > You can also use
> >
> > #include <ComObj.hpp>
> >
> >  try
> >  {
> >    HRESULT hr = JetEngine->CompactDatabase(Source.c_bstr(),
> Dest.c_bstr());
> >    OleCheck(hr);
> >  }
> >  __finally
> >  {
> >    JetEngine->Release();
> >  }
> >
> > instead of
> >
> >  JetEngine->CompactDatabase(Source.c_bstr(), Dest.c_bstr());
> >  JetEngine->Release();
> >
> > if you need to check an error
> >
> > About BCB5 and BCB6 on the same machine - exclude all links to
BCB\Imports
> > and BCB\Lib and BCB\Project (generally BCB\*) from your PATH. They can
> > coexist.
> >
> > ----------------------------------------------------------------
> > Regards,
> > Viatcheslav V. Vassiliev
> > http://www.oledbdirect.com
> > The fastest way to access MS SQL Server and MS Jet (MS Access)
databases.
> >
> >
> > "Daryl" <stockd@cqnet.com.au> �������/�������� � �������� ���������:
> > news:3de92627@newsgroups.borland.com...
> > > Hi
> > > I logged on last night to ask the same question, could not believe my
> luck
> > > when I saw this post.  I attempted to compile my application after
> adding
> > > the example code and I received the following linker errors.
> > >
> > > [Linker Error] Unresolved external 'Jro_tlb::ID_IJetEngine 'referenced
> > from
> > > F:\MY DOCUMENTS\ACCESS2000\VIDEOSTORE\MAIN.OBJ
> > >
> > > and
> > >
> > > [Linker Error] Unresolved external 'Jro_tlb::CLSID_JetEngine
'referenced
> > > from F:\MY DOCUMENTS\ACCESS2000\VIDEOSTORE\MAIN.OBJ
> > >
> > > I have included JRO_TLB.H in the header file,  the other variables in
> the
> > > function CoCreateInstance can be found/viewed by highlighting using
the
> > CTRL
> > > key and selecting it.  I have run out of ideas so any help would be
very
> > > good...
> > >
> > > Actually, I have been having quite a few problems with linker errors
> since
> > I
> > > have installed BB6 pro, I have left BB5 pro installed - I am now
> starting
> > to
> > > wonder if BB6 upgrade was a good move, especially as all my
applications
> > > have had difficulty with the new environment.
> > >
> > > Features that use automation (EXCEL APP) have had to have major work
to
> > get
> > > them to compile, I am still having problems with EXCEL.EXE hanging
> around
> > in
> > > memory (which causes problems to other apps using it).  I had this all
> > > sorted out with BB5 but for some reason the same techniques do not
work
> > with
> > > BB6.
> > >
> > > You can also see other recent posts about Linker errors when trying to
> set
> > > ADO dataset properties, these also worked well in BB5, now will not
link
> > in
> > > BB6.  The solution may be to remove BB5 and BB6 and reinstall only
BB6,
> I
> > > have been steering away from that due to having to get another
> activation
> > > key.
> > >
> > >
> > > Daryl
> > >
> > > "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
> > > news:3de87c27@newsgroups.borland.com...
> > > > Import
> > > > Microsoft Jet and Replication Objects 2.x Library
> > > >
> > > > #include <JRO_TLB.h>
> > > > ...
> > > > void __fastcall TForm1::Button1Click(TObject *Sender)
> > > > {
> > > >  IJetEngine * JetEngine = NULL;
> > > >  CoCreateInstance(CLSID_JetEngine, NULL, CLSCTX_INPROC_SERVER,
> > > > IID_IJetEngine,
> > > >   (void**) &JetEngine);
> > > >
> > > >  WideString Source = "Provider=Microsoft.Jet.OLEDB.4.0;"
> > > >   "Data Source=C:\\Test\\Test.mdb;";
> > > >  WideString Dest = "Provider=Microsoft.Jet.OLEDB.4.0;"
> > > >   "Data Source=C:\\Test\\Compacted.mdb;";
> > > >
> > > >  JetEngine->CompactDatabase(Source.c_bstr(), Dest.c_bstr());
> > > >
> > > >  JetEngine->Release();
> > > > }
> > > >
> > > >
> > > > You can compact database from one file into another. There should be
> no
> > > > users connected to database.
> > > >
> > > > Regards,
> > > > Vassiliev V.V.
> > > > http://www.oledbdirect.com
> > > >
> > > > "adward" <adward_lee@seed.net.tw> �������/�������� � ��������
> ���������:
> > > > news:3de8421d@newsgroups.borland.com...
> > > > > Hi,
> > > > >
> > > > > does anyone kown how to compress Access Database in C++ Builder
6.0?
> > > > >
> > > > > Thanks!!
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID: <3deb1442@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!diablo.theplanet.net!newspeerenv1.svr.pol.co.uk!newsfeed.hostname.nl!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <3de8421d@newsgroups.borland.com> <3de87c27@newsgroups.borland.com> <3de92627@newsgroups.borland.com> <3dea0d97@newsgroups.borland.com> <3deb0cd4@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,88e5d58e39a323f7
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-12-02 00:08:55 PST
From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3de8421d@newsgroups.borland.com> <3de87c27@newsgroups.borland.com> <3de92627@newsgroups.borland.com> <3dea0d97@newsgroups.borland.com> <3deb0cd4@newsgroups.borland.com>
Subject: Re: Question for compress Access DB
Date: Mon, 2 Dec 2002 10:59:59 +0300
Lines: 203
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.99.143
Message-ID: <3deb1442@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038816322 212.188.99.143 (2 Dec 2002 00:05:22 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!diablo.theplanet.net!newspeerenv1.svr.pol.co.uk!newsfeed.hostname.nl!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail