[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
Re: Store image in SQL Express - what is same as OLE_Object?
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.
Re: Store image in SQL Express - what is same as OLE_Object?
Thanks but that thread showed an example for Access 97.
Re: Store image in SQL Express - what is same as OLE_Object?
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).
Re: Store image in SQL Express - what is same as OLE_Object?
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
Re: Store image in SQL Express - what is same as OLE_Object?
From my quote in post #2, it is probably Image.