insert binary file in image column in MS-SQL database

[neilsolent]

I need to insert the binary data from a local file into an image column in a SQL server 2000 database table. Is there a simple procedure for this, in C++ ?

cheers, Neil

[David Crow]

See here and here.

---

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

[Cristian Amarie]

C++ is not much of a help itself. More likely is a DB API you may prefer (or mandatory to use...). OLEDB is probably the best (and hard sometimes) way for C++.

[neilsolent]

Thanks to both of you for the replies. This seems to be quite tricky. I was looking at using SQLPutData(). There doesn't seem to be a T-SQL statement that does such an insert either..

cheers, Neil