Re: Insert binary file content to DB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"quest" <annonymous@xxxxxxxxxxxxx> wrote in message
news:eYjGiR5mFHA.2580@xxxxxxxxxxxxxxxxxxxxxxx
> Database : MS-SQL and Access
> I tried to use ADO to perform the task. I am using visual basic 6.
>

With ADO it is GetChunk and AppendChunk or Parameters.

Use these methods with MSAccess and OLE Objects.
Note the links at the bottom of the page.
http://www.ammara.com/articles/imagesaccess.html

With SQLServer there are various data types you might use. Here is an
example of how to store and retrieve BLOBs.
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

None of these articles are complete but should get you started. Just google
on specific terms and 'VB Sample Code -".NET"' when you need more
information.

hth
-ralph


> "Ralph" <nt_consulting64@xxxxxxxxx> wrote in message
> news:WMWdnb4v85gBpWvfRVn-hQ@xxxxxxxxxxxxxxx
> >
> > "quest" <annonymous@xxxxxxxxxxxxx> wrote in message
> > news:%23rZcQC2mFHA.708@xxxxxxxxxxxxxxxxxxxxxxx
> > > Can someone show me a sample code on how I can insert a binary data
into
> a
> > > database ? How do I retrieve it ? Thanks!
> > >
> >
> > What database?
> > What Data Access Library?
> > What environment?
> >
> > Look up "Data Types" in your "DB's" help file....
> > CLOB, BLOB, RAW, BFILE, BINARY, IMAGE, VARBINARY, &etc
> > GetChunk, BinaryRead, ... &etc
> >
> > -ralph
> >
> >
>
>


.

Relevant Pages

  • Insert binary file content to DB
    ... Can someone show me a sample code on how I can insert a binary data into a ... How do I retrieve it? ...
    (microsoft.public.vb.database.ado)
  • linking tables with ADO
    ... I want to link tables from anathor MS Acess 2000 database using ADO. ... be some sample code. ...
    (microsoft.public.access.formscoding)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)