🚀 go-pugleaf

Try to use Jet OLEDB provider. Connection string is:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydb.mdb;

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

"Gheorghe" <gmusca@dnt.ro> ???????/???????? ? ???????? ?????????: 
news:43b2fa90@newsgroups.borland.com...
> Hi,
>
> I'm trying to read a Memo field in a MS Access DB, using BCB6 and 
> ADOQuery.
> I constantly get the size of the blob as 1 byte, no matter what technique 
> I
> use.
> Any ideas?
>
> Here's the code
> =====================================
> aCon->ConnectionString = "Provider=MSDASQL.1;DSN=MS Access
> Database;DBQ=dbPath;DefaultDir=dbdir;DriverId=25;FIL=MS
> Access;MaxBufferSize=2048;PageTimeout=5;PWD=password";
> aCon->Open();
>
> aQuery->SQL->Clear();
> aQuery->SQL->Add("SELECT BLOBFIELD FROM TABLE;");
> aQuery->Open();
>
> TBlobField * bfield = (TBlobField *) aQuery->FieldByName("BLOBFIELD");
> int len = bfield->Size;        // This is always 1
> =======================================
>
>
>