How can I store images created by ShotGraph on the fly into MS SQL database without temporary file?
In case if file name is not specified, GifImage, JpegImage, PngImage and other such methods of ShotGraph returns variant variable containing safearray. It is one of standard supported types in COM. ADO can convert this type to any binary MS SQL data type: image, varbinary etc. To make such autoconversion, you can either: – open ADO Recordset object using adLockOptimistic option, assign variable containing safearray to the Value property of recordset field and then call Update method of recordset. or – create a SQL stored procedure having parameter of image type. This is the preferred way.
Related Questions
- My Access database stores the file names of images in a text field. How do I use the ActiveX (OLE) controls to view the images in an Access form?
- Why should I choose Pervasive.SQL 2000 as the database for my application instead of MS SQL Server or Sybase SQL Anywhere?
- Where can I download a version with MS SQL database support ?