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

[WarrenW]

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

Thanks,

Warren

[si_the_geek]

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

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

[WarrenW]

Thanks but that thread showed an example for Access 97.

[si_the_geek]

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).

[WarrenW]

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

[si_the_geek]

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