Re: Please Help!How to write/read 7.5 K binary data to SQL database

Hi,

You need to use IMAGE datattype. Essentially it is a binary type but allows
to keep values bigger tan 8000 bytes. Check next KB with an example how to
work with the BLOB-types fields using ADO Stream object

http://support.microsoft.com/default.aspx?scid=kb;en-us;258038

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Pola" <Pola@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E4B40146-4A49-4A53-9ABD-5A3CECA05E7B@xxxxxxxxxxxxxxxx
> My development Tools:
> Visual C++ 6.0, SQL Database, ADO.
> Operating system:Win XP/2000.
>
> We want to write data in binary format, size of data 7.5K to one field in
> SQL database.
> We used "sql_variant" type of field in SQL database.
> We tryed to write and read this field using ADO mechanism,
> but it was unsuccessful.
>
> How we can write and read 7.5k binary data to one field in SQL Database?
> Please Help us to solve this problem?
>
> Thank you,
> Pola
>


.

Relevant Pages

  • Re: Incorrect code page conversion
    ... > I am seeing an incorrect conversion of data stored in SQL database with ... > We are using ADO, but I suspect this is an OLE DB issue. ... What is the ANSI code page on the various boxes? ...
    (microsoft.public.data.oledb)
  • Best way to populate a form with a DataList link?
    ... have to learn a fair chunk of the .NET platform (VS, ADO, WebForms, C# ... the data is stored as a row in an SQL database table. ...
    (microsoft.public.dotnet.languages.csharp)
  • ADO ODBC CONNECTION STRING
    ... I have an access data base with linked tables from an Ms sql database. ... I am trying to use ADO in VBA to list the odbc connection string for each linked table. ... I have some code using DAO that can do this using the "connect" property of a tabledef object. ...
    (microsoft.public.data.ado)
  • Re: Write to a file
    ... >I want to read dada from SQL database and write it to a ... > ASCII comma delimited file. ... Convert an ADO Recordset to Text ... Convert Database Data Between Serveral Formats Using ADO ...
    (microsoft.public.vb.general.discussion)
  • Long binary to MS-Access from MSMWS
    ... How to manipulate a field long binary type that is in MS-Access for the ... I open register using ADO, obtain to recoup all the fields ... execeto this binary long one. ...
    (comp.lang.mumps)