Do blob params work with the MSACCESS native driver?

Article View: borland.public.delphi.database

Article #1990

Back to borland.public.delphi.database Previous Next

#1990

From: Steve S.
Date: Wed, 10 Mar 1999 00:00

17 lines
1218 bytes

I have a parameterized insert query that inserts a file into an
Access97 db.  It works fine with the ODBC driver.  I'd like to use the
MSACCESS native driver, but the ExecSQL aborts if I include the blob
in the insert using either of these 2 methods:

1)  ParamByName('object_data').LoadFromFile(FileName, ftBlob);

2) FileStream := TFileStream.Create(FileName, fmOpenRead);
     try
        ParamByName('object_data').LoadFromStream(FileStream, ftBlob);
     finally
        FileStream.Free;
     end;

Why?

SMS

Technical Details

Message-ID: <36e79dea.4439285@news.mindspring.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,3b2b4c2b347dd931,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 115d96,3b2b4c2b347dd931,start
X-Google-Attributes: gid115d96,public
From: me@mindspring.com (Steve S.)
Subject: Do blob params work with the MSACCESS native driver?
Date: 1999/03/10
Message-ID: <36e79dea.4439285@news.mindspring.com>
X-Deja-AN: 453438635
Content-Transfer-Encoding: 7bit
Organization: MindSpring Enterprises
X-Server-Date: 10 Mar 1999 16:39:30 GMT
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Reply-To: me@mindspring.com
Newsgroups: borland.public.delphi.database,comp.lang.pascal.delphi.databases