[RESOLVED] Store image in SQL Express - what is same as OLE_Object?

In Access I could use OLE_Object to save an image in a table. How is this done in SQL Express 2005?

Thanks,

Warren

I'm not sure about 2005, but for SQL Server 2000 this FAQ thread has the answer:

Quote:

---

for SQL Server, the data type needed for the Picture field is Image (which stores large binary data) rather than OLE.

---

Thanks but that thread showed an example for Access 97.

Erm.. the code there works for any database, all that needs to change is the data type (hence the note that I quoted above) and the ConnectionString (which I assume you already know).

I'm sorry, maybe I did not post my question right. In Access the field type you select when creating a table is OLE_Object. When I use SQL Express, it does not have this field type so I was wondering what field type to use in place of it.

Warren

From my quote in post #2, it is probably Image.