Re: ADO and BLOB

From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
Date: Wed, 27 Apr 2005 22:05:20 -0500

>I migrating from FoxPro to MSSQL, to reach each of them I use ADO
>can anybody tell me an example for using the two databases and copy one
>Blob to the other one?

with SQLDataset do begin
Insert;
fieldbyName('blobField').assign(foxDataset.fieldbyName('blobField'));
end;
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

References:
- ADO and BLOB
  - From: Bolla Sándor

Prev by Date: Re: Cannot Connect ADOConnection at Run-Time
Next by Date: Re: MySQL, ADO and ODBC
Previous by thread: ADO and BLOB
Next by thread: linked tables in Access database
Index(es):
- Date
- Thread

Relevant Pages

ADO and Blob fields
... I migrate from FoxPro to MSSQL and in some cases I had copy 'memo' like field to 'text' type fields. ... I have no problem reading them from the FoxPro database, but I always fail to copy the data into ADO with CreateBLobStream method, but no data has been copied. ...
(borland.public.delphi.database.ado)
Using MSSQL 2000 database in MS Access?
... I have a commercial product that works well under MSSQL 2000. ... simply "attaches" the databases from my product to MSSQL 2000 and my Delphi ... Pro client using ADO and MDAC 2.0 then connects and works with those ...
(borland.public.delphi.database.ado)
ADO and BLOB
... I migrating from FoxPro to MSSQL, to reach each of them I use ADO ... can anybody tell me an example for using the two databases and copy one Blob to the other one? ...
(borland.public.delphi.database.ado)
Re: Why not use DAO?
... You have been refering to DAO vs. ADO when these two things (in the context ... you must have ALREADY used a provider to get to. ... interface for working with JET databases. ...
(microsoft.public.dotnet.languages.vb)
Re: Why not use DAO?
... Happy Christmas an fine holidays for you too. ... interface for working with JET databases. ... discussion about that (DAO was also faster as classic ADO) ... universal provider so ofcourse DAO wil outperform ADO in most ...
(microsoft.public.dotnet.languages.vb)