Hi everybody,

I need to write strings and some binary data into a (previously created)
table that resides on a MS SQL server 2005. What is the best way to do this,
given the facts that the write access shall be as fast as possible, that
there will never be any read access and that I would like to avoid ODBC MFC
classes :)....any suggestions?

Best wishes,

Peter

Re: Writing binary data to sql server by Brian

Brian
Fri Jan 04 13:16:07 CST 2008


"Peter Schmitz" <PeterSchmitz@discussions.microsoft.com> wrote in message news:CE3753A8-B714-4727-AA59-697BF9F149E3@microsoft.com...
> Hi everybody,
>
> I need to write strings and some binary data into a (previously created)
> table that resides on a MS SQL server 2005. What is the best way to do this,
> given the facts that the write access shall be as fast as possible, that
> there will never be any read access and that I would like to avoid ODBC MFC
> classes :)....any suggestions?
>

You can use ADO, or if you want a little better performance, OLE DB. ATL provides some classes to assist with this:

http://msdn2.microsoft.com/en-us/library/8k76sd16(VS.80).aspx

Brian