🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: How can read An Ole object from MSACCESS using BDE

#1782
From: Viatcheslav V. Vassiliev
Date: Mon, 01 Mar 2004 12:35
106 lines
5043 bytes
I am not very good with BDE but as I remember there is setting in BDE named
something like "BLOB size" that limits BLOBs to 32 kB. Change it to 1 MB or
more as needed.

//------------------------------------------
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)

"joe" <giuseppe_grandinetti@libero.it> �������/�������� � ��������
���������: news:40423768@newsgroups.borland.com...
> Hello,
> I tried to save to file the blob field with the code
> DataModule2->Table1FOTO->SaveToFile("c:\\bitmap\\msole.bmp") ;
> ShowMessage(DataModule2->Table1FOTO->BlobSize) ;
> but the size is always 32 kb the ole inserted with MSACCESS Interface was
> more than 200 kb what is wrong?
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto nel
> messaggio news:40409ef4@newsgroups.borland.com...
> > With SaveToStream() function of TBlobField.
> >
> > //------------------------------------------
> > 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)
> >
> > "joe" <giuseppe_grandinetti@libero.it> �������/�������� � ��������
> > ���������: news:40407202@newsgroups.borland.com...
> > > How can save to a file the content of MSACCESS  field.?
> > >
> > >
> > > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto nel
> > > messaggio news:40404159@newsgroups.borland.com...
> > > > If I am not wrong, no. Access uses its own format to store OLE
files.
> > > >
> > > > //------------------------------------------
> > > > 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)
> > > >
> > > > "Giuseppe" <giuseppe_grandinetti@libero.it> �������/�������� �
> ��������
> > > > ���������: news:403fa851@newsgroups.borland.com...
> > > > > Many Thanks for your help!
> > > > > I can use in some way the ole conteiner component bundle in
> cbuilder6
> > ?
> > > > >
> > > > > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto
nel
> > > > > messaggio news:403f64eb$1@newsgroups.borland.com...
> > > > > > If you need only bitmaps - they start at offset 78. For other
> > objects
> > > > look
> > > > > > at Opus DBOLE at http://www.opus.ch/OpenSource/DBOLE/Default.htm
> > > > > >
> > > > > > //------------------------------------------
> > > > > > 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)
> > > > > >
> > > > > > "Giuseppe" <giuseppe_grandinetti@libero.it> �������/�������� �
> > > ��������
> > > > > > ���������: news:403e617e@newsgroups.borland.com...
> > > > > > > Hi All,
> > > > > > >
> > > > > > > I would like to know if is possible to read and display an ole
> > field
> > > > > from
> > > > > > > MSACCES
> > > > > > > Many Thanks,
> > > > > > > Giuseppe
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID: <40432e27$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <403e617e@newsgroups.borland.com> <403f64eb$1@newsgroups.borland.com> <403fa851@newsgroups.borland.com> <40404159@newsgroups.borland.com> <40407202@newsgroups.borland.com> <40409ef4@newsgroups.borland.com> <40423768@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,d99339ecafccaa8a
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-03-01 04:39:49 PST
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <403e617e@newsgroups.borland.com> <403f64eb$1@newsgroups.borland.com> <403fa851@newsgroups.borland.com> <40404159@newsgroups.borland.com> <40407202@newsgroups.borland.com> <40409ef4@newsgroups.borland.com> <40423768@newsgroups.borland.com>
Subject: Re: How can read An Ole object from MSACCESS using BDE 
Date: Mon, 1 Mar 2004 15:35:55 +0300
Lines: 108
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 213.234.218.42
Message-ID: <40432e27$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1078144551 213.234.218.42 (1 Mar 2004 04:35:51 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail